Conditional formating based on blank cell

  • Thread starter Thread starter Kimti
  • Start date Start date
K

Kimti

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
 
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
 
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
 
Back
Top