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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
20,329
Office Version
  1. 365
Platform
  1. Windows
Or...

Formula Is:

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

Hope this heps!
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825

ADVERTISEMENT

Perhaps

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

Legacy 23340

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

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
20,329
Office Version
  1. 365
Platform
  1. Windows
If these formulas do not return the desired result, please provide a sample of your data, along with the actual/expected results...
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,129
Messages
5,857,542
Members
431,885
Latest member
Rsdg

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
Top