Small spreadsheet as follows:

A B C D E F
1 5 6 10 15 27 49
2
3 6 9 17 22 29 36
4 3 14 24 36 39 49
5 2 6 25 28 29 33

Problem:
When I enter a value in A3, B3, C3 and so on, I would like each value to be
checked against the values that appear in cells A1 to F1. If the value does
appear in the range then change the font to a different colour otherwise
leave the font colour the same. The same for A4 to F4 and A5 to F5.

Any ideas on how I could implement this please?

Many thanks,

Joe.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004