Hi,

Select B2.
Under "Conditional Formatting",
Formula Is =ISNUMBER(MATCH($B$2,$A$1:$A$11,0))
Format the font color appropriately.

Regards,
B. R. Ramachandran

"Big Rick" wrote:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick