Conditional Formatting Intermittent at best

[Yogi_Bear_79]

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(H10,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

 

[Guest]

Hi

Don't forget that the CF runs in the order that the conditions are input.
This means as soon as one of the conditions is met, the rest will be
ignored.