Highlight a field if it is over 10% +/- the prior month AND over $1,000 difference.

[ecase]

I'm trying to insert a conditional formatting rule to highlight a cell if it is over 10% +/- the prior month AND over $1,000 difference. I created helper columns, but the highlighting doesn't seem to match. Example of the data is below:

2024/001	2024/002	2024/003
6978.35​	1782.34​	1252.87​
141.36​
1277.49​	1147.84​	1139.09​
294.37​	634.5​	113.78​
265.13​
5000​
374353.46​	216451.88​	224728.79​
176767​
34352.09​	32200.8​	45868.46​
66697​	57044​	38886​
45891.59​	127207.08​	139974.33​
45645.78​
5000​
354793.01​	195468.59​	192271.68​

 

[dermie_72]

Assuming your range is from A2 onwards I used the following conditional formatting formula:

=AND(OR(B2<A2-(A2*0.1),B2>A2+(A2*0.1)),ABS(A2-B2)>1000)

This seemed to work for me when I tested it on the dummy data you provided

 

[ecase]

Thank you so much for your response! I will try this!