Conditional Formatting for multiple values

D

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top