We help IT Professionals succeed at work.

Conditional formatting not always working

bfuchs
bfuchs asked
on
46 Views
Last Modified: 2017-03-25
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
Comment
Watch Question

CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.
CERTIFIED EXPERT

Author

Commented:
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
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT

Author

Commented:
No better solution provided.