Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change background color of cell as value changes
There is no VBA code in that sheet, nor is the Conditional Formatting applied
to the sheet. Simple review this web site: http://www.contextures.com/xlCondFormat03.html Then, apply to your specific needs: Regards, Ryan-- -- RyGuy "S Himmelrich" wrote: Here is the result I'm looking for in regards to changing color as cell value changes in a column ("A"): www.atlantissupport.com/example/example.xls Basically I'm trying to change the background color of the cell as the data changes in Column A. Know that the values in Column A change dynamically with other macro code that is already completed. Also I must pre-define enough colors to cover for expansion in the future (probably no more then twenty). I've kept the duplicates in Column A thinking that this may help in coding this macro and will delete those after the background color is completed. I assume I can use offset for moving the color to the smaller Column B. Hope someone can help...... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
Cell Background Color Change according to numerical value | Excel Discussion (Misc queries) | |||
background color of my cell does not change | Excel Discussion (Misc queries) | |||
Change Cell-Background color into Text | Excel Programming | |||
Change Cell-Background color into Text | Excel Programming |