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 "Cell Value is" parameter, select the "Formula is" parameter, and in
the formula block, enter =C10<"", or whatever parameter you want to test
for. Then copy to the other cells in the row, using the painter.

hth

"AC" wrote:

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!

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!!!!

:-)

"Kassie" wrote:

Hi AC

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

hth

"AC" wrote:

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

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

"AC" wrote:

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!!!!

:-)

"Kassie" wrote:

Hi AC

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

hth

"AC" wrote:

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!