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

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

Thanks for your help, it did not work the way I would like to see. I want to
see only one row to be conditional formated based on the date not being in
one cell for that row. whole idea is that that cell is showing if the task is
complete. If date is not their I want to see different color so it stands out
from the sheet.

Thanks,
Kimti

"Max" wrote:

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

Sorry, I had it the other way around earlier
Same steps, but use this as the CF formula:
=NOT(ISNUMBER($F1))

You could pre-fill the entire sheet with a fill color of your choice as the
"untriggered" background
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Kimti" wrote:
Thanks for your help, it did not work the way I would like to see. I want to
see only one row to be conditional formated based on the date not being in
one cell for that row. whole idea is that that cell is showing if the task is
complete. If date is not their I want to see different color so it stands out
from the sheet.