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!


--
Daniinboston
------------------------------------------------------------------------
Daniinboston's Profile: http://www.excelforum.com/member.php...o&userid=37071
View this thread: http://www.excelforum.com/showthread...hreadid=567979

Conditional Formatting for multiple values
 

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