Is it possible to apple two Conditional Formatting rules to one cell
Hi
We are tracking pupil grades in school. There are two factors I would like highlighted in a cell
For example -
1) If the pupil has scored above 90% - colour cell green (Or red if below 90%)
2) If the score is less than his previous reult - text to red (or green if he is better than last test)
Both rules are needed - as a child could score below 90%, but be on an upward grade trend, which the green text colour would demonstrate. Only one rule does not give a sufficient picture.
Is this possible? Numbers seems to apply only one rule. Am i doing something wrong or should I be approaching the issue from another angle?
Thanks in advance for any advice
MacBook Pro, Mac OS X (10.7.2)