Conditional formatting based on % v’s other cell

[Asw091]

[FONT=&quot][FONT=&quot]Hi, I hope you can help.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]I’m trying to conditional format a colour for A2 based on its percentage to another.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]For example, If A1 if the target (20%) and A2 is the result (15%) that would be 75% of the target.[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]I would like A2’s conditional formatting formulas to calculate[/FONT][/FONT]
[FONT=&quot][FONT=&quot]If less than 90% of A1[/FONT][/FONT]
[FONT=&quot][FONT=&quot]If between 90% and 99.99% of A1[/FONT][/FONT]
[FONT=&quot][FONT=&quot]If equal to or greater than A1 (Which is an option so I’ve done)[/FONT][/FONT]
[FONT=&quot][FONT=&quot][/FONT]
[/FONT]
[FONT=&quot][FONT=&quot]The first two have me confused. What would the formula look like?[/FONT][/FONT]

 

[tyija1995]

Just make a custom rule using =$A$2/$A$1 < 0.9 -> set a format
Make another rule =$A$2/$A$1 < 1 -> set a format
Order it so the < 0.9 rule comes first

 

[arthurbr]

Perhaps try
First CF =A1/A2<0.9
Second CF =A1/A2<=0.9999
Third CF =a1/a2>=1
and format as needed

 

[Asw091]

Hi guys, these have worked just fine on most of my cells. Thanks.

A few of my cells however need to be just if between 91% and 92.99% as that’s the only condition I want on them. Is that possible?

 

[tyija1995]

Hey, make the following rule (if cell A5 for example you wanted to show this specific format):
=AND($A5/$A$1<0.93,$A5/$A$1>=0.91)

 

[Asw091]

?? that works exactly as intended. Thank you so much.

One more formula and my spreadsheet is complete.

I’ve amended it to suit my cells

=AND($I21<0.93,$I21>=0.91)

Now, how would I change that to say if either I21 or I26 in the same formula? As only one has to be at that value to qualify.

 

[Asw091]

Ignore that last one, I just set 2 rules. Thanks again guys.