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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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,213,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

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