Forum Discussion
highlight cells that are .02 higher/lower than one cell
Select the range that you want to format.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'less than' from the second drop down.
In the box next to it, enter the formula=$A$1-0.02
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.Repeat these steps, but with 'greater than' and with the formula
=$A$1+0.02
Select the range that you want to format.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'less than' from the second drop down.
In the box next to it, enter the formula
=$A$1-0.02
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Repeat these steps, but with 'greater than' and with the formula
=$A$1+0.02
- wow this is ridiculously easy lol guess i was thinking way too hard into it., Thanks 😄
