| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a row colour automatically based on a cell input.
Is there a method whereby I can have a input a date in a cell and it will automatically change the row colour? I am tracking a workflow process.
For example, if I input a date into cell C7, then row 7 would change all cells to be colour 'LIGHT BLUE'. if I then, input a date into cell D7, then row 7 would change all cells to be colour 'YELLOW'. if I then, input a date into cell E7, then row 7 would change all cells to be colour 'GREEN'. etc, etc... Any ideas on the best way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill cell colour based on input in another cell | Excel Worksheet Functions | |||
| How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
| How do I stop the font from changing colour automatically? | Excel Discussion (Misc queries) | |||
| Formula for changing colour of a cell based on Neumeric VALUE | Excel Discussion (Misc queries) | |||
| Changing Cell Contents Based Upon User Input | Excel Programming | |||
Threaded Mode
