software

Hi there ... I want to be able to format an entire row of data by
highlighting it a specific colour (say C1 to C10) based on the value of only
one cell (say C10). Conditional Formatting doesn't appear to work for this,
because it only looks at the value in one cell and formats that same cell.
And I'm not sure how to write an if statement where the result is to format a
cell with a colour.

Is there a way to do this?

Thanks!

Hi AC

Conditional formatting is actually the way to go! Instead of accepting the
default quot;Cell Value isquot; parameter, select the quot;Formula isquot; parameter, and in
the formula block, enter =C10lt;gt;quot;quot;, or whatever parameter you want to test
for. Then copy to the other cells in the row, using the painter.

hth

quot;ACquot; wrote:

gt; Hi there ... I want to be able to format an entire row of data by
gt; highlighting it a specific colour (say C1 to C10) based on the value of only
gt; one cell (say C10). Conditional Formatting doesn't appear to work for this,
gt; because it only looks at the value in one cell and formats that same cell.
gt; And I'm not sure how to write an if statement where the result is to format a
gt; cell with a colour.
gt;
gt; Is there a way to do this?
gt;
gt; Thanks!

Thanks so much Kassie! That worked exactly as I wanted!

Funny thing is ... I called our business's tech support yesterday about this
and they told me the question was too hard!!!!

:-)

quot;Kassiequot; wrote:

gt; Hi AC
gt;
gt; Conditional formatting is actually the way to go! Instead of accepting the
gt; default quot;Cell Value isquot; parameter, select the quot;Formula isquot; parameter, and in
gt; the formula block, enter =C10lt;gt;quot;quot;, or whatever parameter you want to test
gt; for. Then copy to the other cells in the row, using the painter.
gt;
gt; hth
gt;
gt; quot;ACquot; wrote:
gt;
gt; gt; Hi there ... I want to be able to format an entire row of data by
gt; gt; highlighting it a specific colour (say C1 to C10) based on the value of only
gt; gt; one cell (say C10). Conditional Formatting doesn't appear to work for this,
gt; gt; because it only looks at the value in one cell and formats that same cell.
gt; gt; And I'm not sure how to write an if statement where the result is to format a
gt; gt; cell with a colour.
gt; gt;
gt; gt; Is there a way to do this?
gt; gt;
gt; gt; Thanks!

Hi AC

The keyword here is Tech support. They seem to only know the technical
side, not the user side! glad I could help

quot;ACquot; wrote:

gt; Thanks so much Kassie! That worked exactly as I wanted!
gt;
gt; Funny thing is ... I called our business's tech support yesterday about this
gt; and they told me the question was too hard!!!!
gt;
gt; :-)
gt;
gt; quot;Kassiequot; wrote:
gt;
gt; gt; Hi AC
gt; gt;
gt; gt; Conditional formatting is actually the way to go! Instead of accepting the
gt; gt; default quot;Cell Value isquot; parameter, select the quot;Formula isquot; parameter, and in
gt; gt; the formula block, enter =C10lt;gt;quot;quot;, or whatever parameter you want to test
gt; gt; for. Then copy to the other cells in the row, using the painter.
gt; gt;
gt; gt; hth
gt; gt;
gt; gt; quot;ACquot; wrote:
gt; gt;
gt; gt; gt; Hi there ... I want to be able to format an entire row of data by
gt; gt; gt; highlighting it a specific colour (say C1 to C10) based on the value of only
gt; gt; gt; one cell (say C10). Conditional Formatting doesn't appear to work for this,
gt; gt; gt; because it only looks at the value in one cell and formats that same cell.
gt; gt; gt; And I'm not sure how to write an if statement where the result is to format a
gt; gt; gt; cell with a colour.
gt; gt; gt;
gt; gt; gt; Is there a way to do this?
gt; gt; gt;
gt; gt; gt; Thanks!