Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Range
Hi
How do I write a formula that can do the following: If any number placed in B1 is higher or lower than (A1+C1)or (A1-C1) then the font will turn Red. However, if it meets these conditions (falls between this range) than the font stays black. Below is an example of my sheet: A1 B1 C1 SIZE SAMPLE 1 TOLERANCE +/- 33 1/2 43 1/2 1/8 23 1/4 It seemed very simple when I was asked to do this but I have not been able to write the formula in the conditional format succesfully. Thank you for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Range
In the conditional formatting dialog
If cell value is Not Bewteen =$A$1-$C$1 and =$A$1+$C$1 -- Regards, Tom Ogilvy "ahishaslauer" wrote in message ... Hi How do I write a formula that can do the following: If any number placed in B1 is higher or lower than (A1+C1)or (A1-C1) then the font will turn Red. However, if it meets these conditions (falls between this range) than the font stays black. Below is an example of my sheet: A1 B1 C1 SIZE SAMPLE 1 TOLERANCE +/- 33 1/2 43 1/2 1/8 23 1/4 It seemed very simple when I was asked to do this but I have not been able to write the formula in the conditional format succesfully. Thank you for your help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for a Range
Thank Mr. Ogilvy! I can't believe it was that simple!!!
"Tom Ogilvy" wrote: In the conditional formatting dialog If cell value is Not Bewteen =$A$1-$C$1 and =$A$1+$C$1 -- Regards, Tom Ogilvy "ahishaslauer" wrote in message ... Hi How do I write a formula that can do the following: If any number placed in B1 is higher or lower than (A1+C1)or (A1-C1) then the font will turn Red. However, if it meets these conditions (falls between this range) than the font stays black. Below is an example of my sheet: A1 B1 C1 SIZE SAMPLE 1 TOLERANCE +/- 33 1/2 43 1/2 1/8 23 1/4 It seemed very simple when I was asked to do this but I have not been able to write the formula in the conditional format succesfully. Thank you for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting for a range situation | Excel Worksheet Functions | |||
Conditional Formatting - Formulas | Excel Discussion (Misc queries) | |||
Need to make a "range" in conditional formatting. | Excel Discussion (Misc queries) | |||
Conditional Formatting - Lookup Range | Excel Discussion (Misc queries) | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |