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.

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.