Forum Discussion
Conditional Formating with tolerances
Hello, I am trying to add conditional formatting to a worksheet using a column as a nominal tolerance and then having a formula to determine if the other cell is large or smaller the cell will turn re...
Let's say you want to format B2:B100.
Select this range. B2 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=OR(B2<A2-0.5,B2>A2+0.5)
or
=ABS(B2-A2)>0.5
Click Format...
Activate the Fill tsb.
Select red.
Click OK, then click OK again.