As real dates are numbers, you could try this ..
Select the entire sheet, apply CF using Formula Is:
=AND(ISNUMBER($F1),$F1<"")
Format to taste OK out
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Kimti" wrote:
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