| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Changing the color of a list entry based on a tolerance
Hi,
I need some help figuring out how to take a list of numbers and make the ones outside of a specified range (109.69 and 109.73) turn red. I need the text or the whole cell to turn red if it is outside 109.69 and 109.73. Thanks for you help |
|
#2
|
|||
|
|||
|
Look at Conditional Formatting
Regards Trevor "Blink" wrote in message oups.com... Hi, I need some help figuring out how to take a list of numbers and make the ones outside of a specified range (109.69 and 109.73) turn red. I need the text or the whole cell to turn red if it is outside 109.69 and 109.73. Thanks for you help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Changing font size in a list box | Excel Discussion (Misc queries) | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Hybrid Mode
