Conditional Formatting

[Guest]

Hi

I am trying to enter more than three conditional formats on particular cells
on my spreadsheet. Excel help says I can only have three, is there a way
around this??

Thanks for any help.
Martin

 

[JE McGimpsey]

If you want up to 6 formats (font color only), see

http://www.mcgimpsey.com/excel/conditional6.html

Otherwise you'll need to use VBA. There are thousands of examples in the
archives:

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

 

[dominicb]

Good afternoon Martc

You can download a free add-in called CFPlus which will handle thirty
formats. Not being a fan of conditional formatting I have never
actually used it, but if you do decide to try it please post back your
thoughts as this question crops up constantly...

http://www.xldynamic.com/source/xld.CFPlus.Download.html

HTH

DominicB