Matching cells

S

Sibbs

I want to match a number in a cell with 6 different columns. if the number
matches any cell in the columns I want the cell that it has matched to
highlight. Can this be done and if so how? Or am I on a hiding to nothing?

Thanks in advance
 
R

Ron Coderre

It seems like conditional formatting in the 6 columns would do what you want:
Format>Conditional Formatting
Formula Is: =(your cell reference here)
Format: (whatever format you want if the cell matches your value)

Does that work for you?
 
R

RagDyeR

Is this what you're looking for?

Select B1 to G1, with the focus in B1 (white), then:

<Format> <ConditionalFormat>
Click "Formula is", and enter this:

=AND($A1<>"",$A1=B1)

Then choose your formatting options, i.e. Pattern = Yellow, Font = Red,
Bold, then <OK> <OK>

Now, any cell in B1 to G1, that matches the number in A1, will turn yellow
and display in red.

You can now select B1 to G1 again, and click on the "Format Painter" icon on
the tool bar (yellow brush), and select B2 to G (whatever), to copy this
format as far down as needed, so that the match to Column A will highlight
the cell in the same row.
--

HTH,

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


I want to match a number in a cell with 6 different columns. if the number
matches any cell in the columns I want the cell that it has matched to
highlight. Can this be done and if so how? Or am I on a hiding to nothing?

Thanks in advance
 
Top