Changing the color of rows - conditional formatting

[Saucer Man]

Using conditional formatting, how can I change the color of the row
(highlight) if a certain cell in the worksheet is not blank? It should
check all rows for this and change them accordingly.

Thanks!

 

[Gord]

Best guess based upon description.

I will assume by "certain cell in the worksheet" you mean "certain
cell in each row"

Select all rows to be colored.

In CF use Formula is:

=$A1<>"" where column A is the "certain cell" in each row.


Gord Dibben Microsoft Excel MVP

 

[Saucer Man]

Thank you very much.

"Gord" wrote in message
Best guess based upon description.

I will assume by "certain cell in the worksheet" you mean "certain
cell in each row"

Select all rows to be colored.

In CF use Formula is:

=$A1<>"" where column A is the "certain cell" in each row.


Gord Dibben Microsoft Excel MVP

 

[Gord]

Thanks for the feedback.

Gord