How do i check if value is in tolerance based of a value in another cell in excel-CodePudding

does anyone know how i can write a formula for conditional formatting to check e.g $5:$5 is plus minus 10% (within tolerance) of value in $A1:1 where the tolerance is specified in a cell and if true then change colour. My data is percentages so e.g cells 1 to 5 will include 10%, 10.1%, 13%, 15%,10% and the tolerance cell will just include a percentage so e.g 10%.

CodePudding user response：

One (quick-and-dirty) option is AND:

=AND(A$5>=A$1*0.9,A$5<=A$1*1.1)

This does assume your data > 0.

CodePudding user response：

Another option:

=ABS(1-A$5/A$1)<=0.1