Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Coley - 31 Mar 2008 18:42 GMT

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"

Reply to this Message

Pete_UK - 31 Mar 2008 19:07 GMT

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

> 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.
[quoted text clipped - 3 lines]
> Formula is =VLOOKUP($A$4,Data,5,FALSE)="UTStarcom"
> Formula is =VLOOKUP($A$4,Data,5,FALSE)="Samsung"

Reply to this Message

Rate this thread: