Conditional Formatting

[Coley]

I have a sheet that prints price tags. I want the price tage to be 1 of 7
colors. I am using these conditional formats to get 3 colors.... I need 7.
Any ideas?

Formula is =VLOOKUP($A$4,Data,5,FALSE)="Motorola"
Formula is =VLOOKUP($A$4,Data,5,FALSE)="UTStarcom"
Formula is =VLOOKUP($A$4,Data,5,FALSE)="Samsung"

 

[Pete_UK]

If you have XL2003 or earlier, you are limited to 3 conditional
formats. Bob Phillips has a CFPlus add-in which gives you up to 30,
but his website is unavailable at the moment. You could also do it
with a macro - a Google search of these groups should reveal something
of use.

Hope this helps.

Pete