Conditional Formatting referencing Conditional Formatting in another column

[pherman]

Hello! I've been trying to figure out a way where I can write a conditional formatting equation that references the conditional formatting in another column. In the regional response rate column, I've ranked each customers' response rate compared to their regional average, and applied the conditional formatting rules : red <84%, yellow 85% - 104%, green 105% and greater. I want to apply conditional formatting rules to Column A (response rate) by referencing the color in Column B. For example, 67.21% would change to green because that particular customer ranks 143% in their regional response rate. Thank you in advance for your assistance!

Response Rate (Column A)	Regional Response Rate (Column B)
0.00%​	0%
0.00%​	0%
0.00%​	0%
0.00%​	0%
0.00%​	0%
67.21%​	143%
54.59%​	116%
9.29%​	20%
55.70%​	109%
28.35%​	60%
29.08%​	57%
51.06%​	100%

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B
1	Response Rate	Regional Response Rate
2	0.00%	0%
3	0.00%	0%
4	0.00%	0%
5	0.00%	0%
6	0.00%	0%
7	67.21%	143%
8	54.59%	116%
9	9.29%	20%
10	55.70%	109%
11	28.35%	60%
12	29.08%	57%
13	51.06%	100%
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B13	Expression	=$B2>104%	text	NO
A2:B13	Expression	=AND($B2>84%,$B2<105%)	text	NO
A2:B13	Expression	=$B2<84%	text	NO

 

[etaf]

you can use the same rule
formula
select columns A and B
then use 3 formulas

: red <84%,
$B1 <84%


yellow 85% - 104%,
$b1 < 104%


green 105% and greater.

$b1 >= 104%

Order and click on stop if true

Book2
	A	B	C	D	E	F	G	H	I	J	K
1	Response	Regional Response Rate (Column B)								Response	Regional Response Rate (Column B)
2	Rate (Column A)									Rate (Column A)
3	0.00%	0%								0.00%	0%
4	0.00%	0%								0.00%	0%
5	0.00%	0%								0.00%	0%
6	0.00%	0%								0.00%	0%
7	0.00%	0%								0.00%	0%
8	67.21%	143%								67.21%	143%
9	54.59%	116%								54.59%	116%
10	9.29%	20%								9.29%	20%
11	55.70%	109%								55.70%	109%
12	28.35%	60%								28.35%	60%
13	29.08%	57%		: red <84%, yellow 85% - 104%, green 105% and greater.						29.08%	57%
14	51.06%	100%								51.06%	100%
15
16
17
18
19
20
21
22
23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:B14	Expression	=$B3>=1.05	text	NO
A3:B14	Expression	=$B3<0.84	text	YES
A3:B14	Expression	=$B3<1.04	text	YES