View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Saucer Man Saucer Man is offline
external usenet poster
 
Posts: 54
Default Changing the color of rows - conditional formatting

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