You can trick it into doing 4 but not five unless you build a program in vb.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Una" wrote:

Hi

I was just wondering whether there was a way that I can add more than three
conditional formats. I have five different options from a drop down column
that I want to give a different colour for reporting. I would appreciate any
help.

Many thanks

Úna