As you said, conditional formatting only supports 3 formats.

If it is numbers, normal formatting can color the font for some additional
conditions.

Otherwise, you would have to use the Change or calculate events to run code
to do the formatting.

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Sherif" wrote in message
...
I need to apply some conditional formatting to my Sheet, however by using
the
preset function I can only apply up to 3 different formattings, I need
more,
how can I do it?