Link to home
Start Free TrialLog in
Avatar of bfuchs
bfuchsFlag for United States of America

asked on

Conditional formatting not always working

Hi Experts,

I have a textbox that is set to display red fonts in two conditions, see attached.

While the first condition works, the second condition only partially works, meaning if I only have that cond. in place then it works, however if I have another condition besides this then it doesn't.

What is the reason?
Untitled.png
Avatar of PatHartman
PatHartman
Flag of United States of America image

Whichever condition returns true first, is the one that rules.  So if some date is less than current date + 30, then that condition is applied and no other condition is checked.
Avatar of bfuchs

ASKER

Hi,
Whichever condition returns true first, is the one that rules.
I know that, my problem is in a case when first condition is not true and second is true, it doesn't get red.

Thanks,
Ben
ASKER CERTIFIED SOLUTION
Avatar of bfuchs
bfuchs
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bfuchs

ASKER

No better solution provided.