Use conditional formatting over the first range.

Set condition 1 to Formula-is option and in next box add
=COUNTIF($D$1:$F$5,A1)0
Format as appropriate.

$D$1:$F$5 is range being tested. Change as appropriate.
A1 is the first cell of the range being conditionally formatted.

There are lots of Youtube vids which may prove informative if you
want to learn more. Type conditional formatting in the site search
box to find vids on this particular aspect of Excel.

Regards
Paul



"DanL" wrote in message
...
I would like to search a spread sheet for a specific range value Ie

c1 c2 c3 c4 c5 c6
20 30 40
20 30 40

When 20 30 and 40 are found in neighboring columns I would like to turn
the
background of these 3 cells blue. How would I code this?

Thanks in advance - Dan