| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi,
I'm trying to format some cells so that: - if cell value is between -5 and 5, it formats the font Green - if cell value is between -6 and -20 or 6 and 20, it formats the font Yellow - if cell value is between -21 and -100 or 21 and 100, it formats the font Red Any assistance would be greatly appreciated. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
I got it!
"Judi" wrote: Hi, I'm trying to format some cells so that: - if cell value is between -5 and 5, it formats the font Green - if cell value is between -6 and -20 or 6 and 20, it formats the font Yellow - if cell value is between -21 and -100 or 21 and 100, it formats the font Red Any assistance would be greatly appreciated. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Conditional Formatting Help | Excel Discussion (Misc queries) | |||
Linear Mode
