Conditional formatting based on % in other cell

[D-smoke]

Hello,
I want to color format a cell based on a percentage value in another cell but I just can't get my head around how to solve it. I've attached a file that explains it better.

E.g.
The formatting for A1 should be something like:
If A2 is
> +/- 10% RED
+/- 6-10% YELLOW
+/- 5% GREEN

Any ideas on how to solve this?
Conditional formatting based on %.xlsx

[benishiryo]

hi D-smoke. but you have nothing in A1 & A2. assuming you want to highlight A1 based on the % in J5, then select the range you want to apply to (say A1:A10)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is:
=ABS($J$5)>10%
format as red

repeat the steps but with this formula for yellow:
=AND(ABS($J5)>5%,ABS($J5)<=10%)
you don't have a range for above 5% to 6%, so i included it here.

and for green, is it exactly 5%? for exact match, try:
=ABS($J$5)=5%
otherwise, use AND like i did for YELLOW

[D-smoke]

Awesome! This works perfectly!
Thanks ever so much.