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. |