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
--- Posted via
news://freenews.netfront.net/ - Complaints to
---