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.
--
Andy.
"Yogi_Bear_79" wrote in message
...
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
|