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.