Is there a way to implement more than 3 conditional formats

[Harlan Grove]

Put your question in the body of your message.

You have 4 - the default format too. No more than that without complicated
macro programming.

 

[Gord Dibben]

Carol

If data is numeric JE McGimpsey has instructions to allow up to 6 CF.

If not numeric, you would need VBA code.

Post back if need VBA.


Gord Dibben Excel MVP

 

[Bob Phillips]

You could try the free add-in at
http://www.xldynamic.com/source/xld.CFPlus.Download.html

--

HTH

RP
(remove nothere from the email address if mailing direct)