View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hojo Hojo is offline
external usenet poster
 
Posts: 3
Default Conditional Formatting - allowing for Blank Cells

I have a form that we are setting up to calculate the number of days someone
may have missed their due date on a project. We have if cell value is
greater than 0 it turns the cell red if we have if the cell value is less
than or = to 0 it turns green. But since not all of the projects have been
entered if the cell is blank it still turns green. Any ideas to write a
condition that recognizes a null value. I already tried if cell value is
"null" - it didn't work.

Thanks,