Trying to set up a spreadsheet to colour test scores of students different
colours based on a target score column.
If score is greater than the target column then i want it to colour it
green, if same as the score then orange, and less than the score, red.
Unfortunately I've got 300 pupils all with different 'targets' and I can't
figure out a way to set the conditional formatting to a 'cell value' (e.g
'C2') rather than a number (eg '3'). I've tried sorting all children in to
target order then conditional formatting manually the whole lot. But when I
re-order children alphabetically all the formatting is 'lost'.

Any help very much appreciated. I can put what I've got so far as a link
if anyone wants some data to play with. Just let me know.

Many thanks. Graham.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.772 / Virus Database: 519 - Release Date: 01/10/2004