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 |