View Single Post
  #2   Report Post  
Old August 9th 11, 07:45 PM posted to microsoft.public.excel.worksheet.functions
Gord Gord is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2011
Posts: 86
Default Changing the color of rows - conditional formatting

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:// - Complaints to ---