Forum Discussion
Jessssssssss
Sep 21, 2023Copper Contributor
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 ...
- Sep 21, 2023
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