Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell Color dependent on Cell Contents
In VBA code, I need to have the background color of the cells in Column H
change depending on Text in the Cell. I can not use conditional formating because I have to many codes and colorsr. Code A-1 background color Green A-2 background color Green G-1 background color Yellow G-2 background color Yellow G-3 background color Orange CA-1 background color Blue GA-1 background color Black GA-2 background color Gray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
directing cell contents dependent on its value | Excel Worksheet Functions | |||
how to change color of cell based on contents of cell | Excel Discussion (Misc queries) | |||
Making cell contents dependent on another cell | Excel Worksheet Functions | |||
Making cell contents dependent on another cell | Excel Discussion (Misc queries) | |||
Change cell color based on contents | Excel Discussion (Misc queries) |