Conditional Format

J

Jimmytech

That's what I was messing up! It was the ordering, not the formula!
Thank you. Now if I have my =AND(E2="Y") for one and no formatting
and my second =C2<TODAY() Red bold format, I should be able to mak
rule 3 =C2<TODAY()-2 format Yellow bold and have anything 2 days clos
to due yellow, YES
 
M

Myrna Larson

RE: =AND(E2="Y")

You only need AND when you are testing two conditions, both of which must be
true. If that's your only condition =E2="Y" will do.
 
Top