| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - getting input from another cell
I have conditional formatting on column M based on a dollar value (color
changes highest to lowest). In column I, you can input "D", "F", or "T". If "T" is chosen, then I want the corresponding cell (same row) in column M to be a different color than the gradient already being used in the rest of column M. Basically, if you choose "T" in column I, it would sort of exclude the corresponding cell in column M my making it stand out as a completely different color than the rest of the gradient. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Input Time Delays | Excel Discussion (Misc queries) | |||
| Conditional Formatting to differentiate between Input and Calcs | Setting up and Configuration of Excel | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional formatting w/ color as input vs output | Excel Worksheet Functions | |||
| Formatting to show 0 as first number in a cell when input | Excel Worksheet Functions | |||
Threaded Mode
