Consider:

=((A1=B1)+(A1=C1)+(A1=D1)+(A1=E1))>0 will be true if A1 matches any of
B1,C1,D1,E1

Use conditional formatting on A1 with formula is and the above equation and
a hi-light background color. Copy down the column.

Apply a similar equation to column B, etc.
--
Gary''s Student


"rojoreds" wrote:

>
> I have searched the forum and find some things that help but not quite
> enough. I have a table of numbers. In fact there are 300 rows of 5
> colums of numbers. What I would like to do is to change the color of
> the number if it matches one of 5 other numbers.
>
> Example Reference #s 2 6 23 43 48
>
> 01 02 09 08 14
> 06 14 23 43 44
> 03 11 23 24 52
> etc etc
> etc etc
>
> The example list is already populated. When the reference numbers are
> entered I want any number in the example list that matches any number
> in
> the reference list to change to a specified color. Any way to do this.
> Conditional formatting would work I think but I can only have three
> condition and I need at least 5 maybe 6. Thanks
>
>
> --
> rojoreds
> ------------------------------------------------------------------------
> rojoreds's Profile: http://www.excelforum.com/member.php...o&userid=31431
> View this thread: http://www.excelforum.com/showthread...hreadid=511221
>
>