Conditional Formatting for multiple values

[Daniinboston]

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

Thanks

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3