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 based on blank cell

I have data in the few cells in the row. I would like to format different
color based on one cell in the row, for example:
A B C D E F
12 12 56 43 87 Oct 12, 2009
76 98 56 34 21

I want to highlight row 2 as F2 is blank (there is no date).

Thanks in advance for your help.
Kimti