help with conditional formatting

[Chris Barnett]

hello there

i could really do with some help in creating a table that produces a
traffic light style way for showing performance in exam progress.

a red for underperformance - orange for working at capability and green for
better than expected performance.
the formating is related to the cells in the next columns - min perf & max
perf.

i've managed to do this using the conditional formatting option. however
not all pupils are involved in each subject and so i would like those cells
to stay unformatted (no fill) - with no luck so far. it seems that you can
only have 3 formatting options but i think i really need 4. Is there an
alternative way?

example is below

A B C D E
1 name current min perf max perf
2 mike thomas B C B -
cell C2 will be in orange
3 susie lowes D B
- cell C3 will be in red
4 rick
- cell C4 should remain unformatted
5 aaron fletcher A C C -
cell C5 will be in green

thanks for any help you can give me here

cheers
Chris Barnett
(e-mail address removed)

 

[Bob Phillips]

Use a formula, something like

=AND(A1<>"",A1>75%)

or whatever criteria that you apply