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.
 
Upvote 0
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
 
Upvote 0
Or...

Formula Is:

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

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

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top