Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell color by clicking the cell
I have a vacation schedule for employees. As they turn in a vacation request,
I add it to the spreadsheet as pending. Once it is approved by management, I would like to click the cell and have it turn green and the letter 'A' appear as approved. If it is denied, the cell should be turned red and the letter 'D' inserted. The original input cell has a '1', '2', '3' (ist, 2nd, 3rd chocie) or a V as a non-choice vacation (usually a one day request. The pending status is always normal white cell shading. Is there any way of cycling through the cell color choices....green to red...as I click on the cell ? I'm sure I would have to do each cell separatly (2 week vacation, for example) but that would still be easier than highlighting and re-typing every cell. I did notice a 2007 posting for changing from one color to the next, but not sure about cycling through with multiple choices. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Cell Color by clicking on a cell | Excel Programming | |||
Changing cell text color based on cell number | Excel Programming | |||
Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
Code for making a cell chage color by dbl clicking, with either a | Excel Programming | |||
changing cell value by double clicking it with out vba/macros | Excel Programming |