View Single Post
  #1   Report Post  
Big Rick
 
Posts: n/a
Default Conditional Format Problem.

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