Solved Conditional formatting combining and and or

November 22, 2016 at 13:06:04
Specs: Windows 7
I am trying to add conditional formatting using 2 conditions:

=AND($V7<81,$G7="CIAPPR",$P7="Purchase",$I7="")

I want to add an OR statement that says if $AC7="CRF" the conditional formatting also applies


See More: Conditional formatting combining and and or

Report •

#1
November 22, 2016 at 16:06:16
✔ Best Answer
I think this is what your looking for:

=OR(AND($V7<81,$G7="CIAPPR",$P7="Purchase",$I7=""),$AC7="CRF")

See how it works for you.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question