Conditional formatting with using OR and AND

October 5, 2016 at 08:03:53
Specs: Windows 7
I currently have this conditional format working but I need to add another condition.
I need to add that if G7=0% or less than 65%

current formula:
=OR(C7<95%,E7<87.5%,G7<65%)

can someone help me add this, I tried this one but it didn't work:
=OR(C7<95%,E7<87.5%,G7<65%,G7=0%).


See More: Conditional formatting with using OR and AND

Reply ↓  Report •


#1
October 5, 2016 at 12:06:10
I'm confused.

0% is less than 65%. Why do you need to add a specific condition for G7=0% when that condition is already covered by G7<65%

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •

#2
October 5, 2016 at 14:18:37
You are correct I just discovered that it was a simple mistake where I was not including the full range in the conditional formatting.

Reply ↓  Report •

Related Solutions


Ask Question