View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kimti Kimti is offline
external usenet poster
 
Posts: 38
Default Conditional Formating

I have data in multipal rows and one column is for date. If date column is
blank I would like to highlight rest of the row in color.

A B C D E F
21 32 12 54 12 OCT 12, 2009
23 43 12 11 34

As F2 is blank I would like to highlight row 2 to be yellow. This should
happen only once I start placing the data in this row.

Thanks in advance for your help.
Kimti