Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoColoring
I would like to auto color my (row) data based on the content in a column.
For instance if Column A was "Type" and if row 2,4,5 had "A" then they would all be green, if row 3,7 were "B" then they would be red and if row 6 was "C" then it would be yellow. And so on in that fashion. I want the whole row to be that color, and the color would be the background color. I would like as much of this to be automatic so color selection for each new type would be automatic (256 color support is fine, I don't need more then that many types). I am sure there is someway of using an array to runs this but I am unsure of how to store it, run it, etc. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoColoring
1 solution might be using Conditional formatting
Try the following link http://www.xldynamic.com/source/xld.html other option is via a VBA Sub using EntireRow.Interior.ColorIndex = 3 ' as eg "Tim" wrote: I would like to auto color my (row) data based on the content in a column. For instance if Column A was "Type" and if row 2,4,5 had "A" then they would all be green, if row 3,7 were "B" then they would be red and if row 6 was "C" then it would be yellow. And so on in that fashion. I want the whole row to be that color, and the color would be the background color. I would like as much of this to be automatic so color selection for each new type would be automatic (256 color support is fine, I don't need more then that many types). I am sure there is someway of using an array to runs this but I am unsure of how to store it, run it, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|