Conditional Formatting for multiple values

I am trying to conditionally format a spreadsheet with 18 different values. For example, if the cell says A it turns blue, if it says B it turns green, etc., but with 18 different cell values. I can only get the conditional formatting tab to allow 3 values. Does anyone know how to get around this?

Thanks!

Can't do it with regular CF.........you would have to use VBA to get there.

Vaya con Dios,
Chuck, CABGx3



"Daniinboston" wrote:

>
> I am trying to conditionally format a spreadsheet with 18 different
> values. For example, if the cell says A it turns blue, if it says B it
> turns green, etc., but with 18 different cell values. I can only get
> the conditional formatting tab to allow 3 values. Does anyone know how
> to get around this?
>
> Thanks!
>
>
> --
> Daniinboston
> ------------------------------------------------------------------------
> Daniinboston's Profile: http://www.excelforum.com/member.php...o&userid=37071
> View this thread: http://www.excelforum.com/showthread...hreadid=567979
>
>