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_gr...ugroup=*excel*

In article ,
"Martc" wrote:

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??