highlight specific cells in array

J

joker

I have an array (c1:f20) For example: in this array the value 10 occurs
3 times. In cell A1 i submit the value "10" , now i want to highlight
the cells in the array that contain the value 10. How can i solve
this?

thanks
 
R

RagDyeR

Select C1 to F20
Then,
<Format> <ConditionalFormat>

Expand the left box and click "Formula Is"

And enter this formula:

=C1=$A$1

Then choose your formats, and <OK> <OK>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have an array (c1:f20) For example: in this array the value 10 occurs
3 times. In cell A1 i submit the value "10" , now i want to highlight
the cells in the array that contain the value 10. How can i solve
this?

thanks
 
Top