To highlight *only* the first occurrence of the cell that matches the data
in A1,
Select Column B, from B1 to whatever, with the focus of the selection in B1
(colored white), then:
<Format <Conditional Format,
Change "Cell Value Is" to "Formula Is",
And enter this in the next box:

=AND(COUNTIF($B$1:B1,$A$1)=1,$A$1=B1)

Click on "Format" and choose whatever format you wish,
Then <OK <OK

To highlight only the first *2 matches*, enter this formula:

=AND(OR(COUNTIF($B$1:B1,$A$1)=1,COUNTIF($B$1:B1,$A $1)=2),$A$1=B1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"MS Excel" wrote in message
...
Per below list, i want to change colour of a cell whose value matches with
CELL A1 contents. For example:

A1 = 239.05
Column B
1) 235.66
2) 154.60
3) 239.05
4) 522.05

As I enter 239.05 in cell A1 it automatically change colour of CELL B3
(that's equal to 239.05). Any possibility?
Be noted that it should seach for the first occurence only.. also what
amendment can enable the proposed solution to search for all first & next
occurence ?


Regards,
Syed