View Single Post
  #1   Report Post  
Yogi_Bear_79
 
Posts: n/a
Default Conditional Formatting Intermittent at best

I have a column in my spreadsheet tht uses conditional formatting. Each cell
in the column is idnetical in it's setup. The conditional formatting only
seems to work on about 75% of the cells.Any idea on how to force it to work
on all of them properly?

CONDITION 1
=(IF(ISERROR(DATEDIF(H10,NOW(),"d")),0,(DATEDIF(H1 0,NOW(),"d")))0)

Make the text RED

CONDITION 2
If the date is between =NOW()+60 and = NOW()+31
Make the text green

CONDITION 3
If the date is between = NOW()+30 and =NOW()+1 Make the text Orange