I'm trying to highlight cells within 5% of goal green and those that are outside the range to be highlighted red
I tried to use conditional formatting formula and wrote it as the following, but it's not working out.
=(ABS(A2-$A$1)/$A$1)<=0.05
Where is my error? Also, where should my anchors be for the first cell I select? The goal value is a fixed value/cell so I anchored that one, not sure how to place the anchors if I want the formula rule to apply to all the cells in the range I select.
<tbody>
</tbody>
I tried to use conditional formatting formula and wrote it as the following, but it's not working out.
=(ABS(A2-$A$1)/$A$1)<=0.05
Where is my error? Also, where should my anchors be for the first cell I select? The goal value is a fixed value/cell so I anchored that one, not sure how to place the anchors if I want the formula rule to apply to all the cells in the range I select.
A | B | C | |
1 | 405 | <-Goal | |
2 | 468 | 414 | 534 |
3 | 474 | 420 | 564 |
4 | 456 | 426 | 546 |
5 | 468 | 432 | 600 |
<tbody>
</tbody>