Use nested "IF" command. In excel 2003, you can nest IF to a depth of 7. In
excel 2007, I found a help file that said we could nest to a depth of 64 ...
example below IF(condx=1,blue,IF(condx=2,red,IF(condx=3,green,no ne)))
to a depth of 3 ... I have used depth of 7 in excel 2003 - works ok
Lin


"Mat from Nancy, France" wrote:

Excel is a tremendously powerful application. Why the miserly, or at least
seemingly arbitrary, restriction to three (magic number?) conditional formats
for a given cell or series of cells?

I am a university lecturer/administrator at the Université de Nancy 2 in
France and use Excel amongst other things to record details for incoming
admissions candidates for a vocational English course. The admissions
procedure includes a test whose result determines whether candidates are
refused, or allowed into various different level groups. I would like the
column which shows the decision to automatically display "refused" in red,
"abandon" in red italics, "accepted advanced level" in blue, "accepted
intermediate level" in green, and so on. Why can I only program three
conditions and not more (or can I, and I just haven't figured out how to?).



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming