| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating from Drop Down List
Afternoon,
I have a drop down list with five options in cell H3: Accident Damage Transferred From Transferred To Operational Service Now in a seperate cell (L3) I want to use conditional formating so that when Transferred From is selected, then in the cell it will say "Sending Depot" in Red and when Transferred To is selected, then the cell will say "Receivig Depot" in Green. Any suggestions. Oh yes, forgot, compliments of the season. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| Order of drop down list | Excel Discussion (Misc queries) | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Threaded Mode
