# Confused.

L

#### Legacy 23340

##### Guest
Hi, I have a problem as stated below

I have cells E7:E29 that contain numeric data.

I also have master cells that contain core numeric data those cells are E4:E5

I also have a tolerance cell B4 with a specified number.

Now here goes IF any numeric value within E7:E29 is within the tolerance value of the master cells then those cells(e7:e29) become red.

can anyone help out? i am confused myself on what to start out with my mind goes in a vicous loop.

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Select E7:E29 and choose Format|Conditional Formatting from the menu. Condition 1 Formula is:

Code:
``=OR(AND(E7>=(\$E\$4-\$B\$4),E7<=(\$E\$4+\$B\$4)),AND(E7>=(\$E\$5-\$B\$4),E7<=(\$E\$5+\$B\$4)))``

Choose a Format and click OK twice.

Hi

You should be able to use Conditional Formatting. Please specify how the tolerance values operate (ie as a percentage, as an absolute value etc) and provide example values in E4:E5 and E7:E29 and B4.

Thanks

Richard

Or...

Formula Is:

=OR(ABS(\$E7-\$E\$4)<=\$B\$4,ABS(\$E7-\$E\$5)<=\$B\$4)

Hope this heps!

Perhaps

=MIN(ABS(\$E7-\$E\$4),ABS(\$E7-\$E\$5))<=\$B\$4

this is very confusing. i am lost. can you guys explain your formulas?

If these formulas do not return the desired result, please provide a sample of your data, along with the actual/expected results...

Replies
3
Views
221
Replies
24
Views
662
Replies
4
Views
481
Replies
2
Views
304
Replies
7
Views
363

1,218,743
Messages
6,144,225
Members
450,531
Latest member
avril18

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back