Forum Discussion
highlight cells that are .02 higher/lower than one cell
I'm trying to highlight cells that are higher/lower than .02 of a certain cell for comparison
so i have 50 in cell a1 and if i put anything less than 49.98 i want it to be highlighted
(same for 50.02)
I know how to conditional format to do less/more than but 50 will not always be my main number to use for this so i need help figuring out how to do this. thanks 😄
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
2 Replies
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 😄
