Conditional formatting not always working

bfuchs
bfuchs used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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
I figured out a workaround..

Included the logic of the first condition in my function so its only checking now for one condition.
See attached.

Thanks,
Ben
Untitled.png
No better solution provided.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial