Aug 16 2021 07:56 PM
=IF(AND(OR(K2<=TODAY,L2=Y)),(OR(P2<=TODAY,Q2=Y)))
I am trying to get the row to highlight if either (K2 or L2 is True) AND (P2 or Q2 is True)
Date in K2 is equal to or less than TODAY OR if L2=Y
AND
Date in P2 is equal to or less than TODAY OR if Q2=Y
This is what I am trying to use but it's not working:
=IF(AND(OR(K2<=TODAY,L2=Y)),(OR(P2<=TODAY,Q2=Y)))
Help, please
Aug 16 2021 08:20 PM - edited Aug 16 2021 08:21 PM
SolutionTry it this way:
=AND(OR($K2<=TODAY(),$L2="Y"),OR($P2<=TODAY(),$Q2="Y"))
You don't need the IF, the correct syntax for the TODAY function is to add the two brackets, and when you compare to a text you must enclose the text in quotation marks. And finally, you need to fix the column references with a $ sign.
Aug 16 2021 08:31 PM
Aug 16 2021 08:44 PM
@brendababy02 Add another rule (should be the first one in the list) and mark it to "Stop if true". For instance, if A2 is empty than don't format anything.
=ISBLANK($A2)
Aug 16 2021 08:57 PM
Aug 16 2021 08:20 PM - edited Aug 16 2021 08:21 PM
SolutionTry it this way:
=AND(OR($K2<=TODAY(),$L2="Y"),OR($P2<=TODAY(),$Q2="Y"))
You don't need the IF, the correct syntax for the TODAY function is to add the two brackets, and when you compare to a text you must enclose the text in quotation marks. And finally, you need to fix the column references with a $ sign.