Much appreciated Frank. Sorted now.
Joe.
"Frank Kabel" wrote in message
...
Hi
try the following:
- select cells A3:F10
- goto 'Format - Conditional Format'
- enter the following formula
=COUNTIF($A$1:$F$1,A3)0
- select your format (other font)
--
Regards
Frank Kabel
Frankfurt, Germany
"Joe Best" schrieb im Newsbeitrag
...
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
---
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