Originally Posted by
JBeaucaire
Most CF formulas don't need to be IF tests, you simply test the criteria and without the IF the result will return TRUE/FALSE by design. To understand this, put this formulae in some cells:
=1=1 (should show TRUE)
=2>3 (should show FALSE)
Now just do that same thing with your more complex tests.
RED Rule #1:
=AND(TODAY()>$E157, $E157>0, COUNT($F157,$J157)=0)
BLUE Rule #2:
=AND(TODAY()-$F157>1, $F157>0, COUNT($G157,$J157)=0)
YELLOW Rule #3
=AND(TODAY()-$G157>1, $G157>0, COUNT($H157,$J157)=0)
NOTE: That's 3 CF rules, that's all you get in one cell in Excel 2003. You should be upgrading soon, yes?
Bookmarks