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
On Tue, 9 Aug 2011 12:23:25 -0400, "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.
--- Posted via news://freenews.netfront.net/ - Complaints to ---