Conditional Format Coloring

**agsankaa** · 08-19-2010, 02:25 PM

My problem is that I want to color cells based on value. The color is irrevelant and I want it to be random. For instance I have 1000+ unique values, and I want items with each value to have same color. I know they'll be duplicating colors, I just want unique color, and it doesn't matter what it is. I don't think you can do this with conditional formatting unless you do it manually for all 1000+ entries.

Example:

Order# QTY
1 25
1 32
1 33
2 21
2 12
3 15
3 18
3 19

So I want all the #1 to have same color, all the 2 to have same color, all the 3, and so on.

Any tips? Thx!

**Cheeky Charlie** · 08-19-2010, 02:32 PM

Which version of Excel are you running?

Depending on how many colours you have, they won't look very unique to the human eye... have you considered this?

**agsankaa** · 08-19-2010, 02:56 PM

Originally Posted by Cheeky Charlie

Which version of Excel are you running?

Depending on how many colours you have, they won't look very unique to the human eye... have you considered this?

2007. I just want it to be easy on the eyes. I have to manually look at it, and if they are grouped together by color, it will make it easy to look at it. The whole purpose is just to have the same orders by same color so I can differentiate it from the next line item.

**Cheeky Charlie** · 08-20-2010, 05:21 AM

OK, well we'd need to use a macro to format all those colours (which is fine), but if you only need to differentiate one row from another, you could use conditional formatting like this:
formula is:
=mod($A1,4)=0
(colour 1)
=mod($A1,4)=1
(colour 2)
=mod($A1,4)=2
(colour 3)

If this isn't enough differentiation, someone with xl07 would need to write a macro.

I want xl07