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"

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

On Mar 31, 6:42*pm, Coley wrote:
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"