Search Column and Highlight Matches in a Range

[tjtoad2]

I have a 10 x 10 range of cells that are numbered 1-100 (Squares for NCAA Pool). On another tab in the same workbook I have a "winners column" which is formula based that returns which cell won based on a search. To provide a visual of how many different cells have won I would like to highlight each cell in the range which matches the number in the "winners column".

There may be duplicates which would make it even more interesting if I could highlight different colors based on the number of times the cell won.

Any ideas would be appreciated. Thanks.

 

[Special-K99]

Not enough info.
Are you match by row where, e.g. A2:J2 = L2, A3:J3 = L3 ?

Try this

Select the range to highlight (in this case the grid)

Conditional Formatting
New Rule
Use a formula to determine...

=(A1:CJ1=$L1)

format as required

where L1 is the winners column

This will highlight all the cells that match the row in column L the same colour.

If the winners column is just one number change the value from $L1 to $L$1

Gonna need some example data to highlight different colours as it's not clear.

 

[tjtoad2]

Special-K99,
Thanks for the reply. Below is an example of a section of my grid. As I mentioned this is setup as a NCAA Pool. So depending on the Final score of each basketball game I take the last digit of the winning team (B1:D1) and last digit of the losing team (A2:A4) and then find the winning square. Example Score: 75-72 = Winning Square C2. The winning numbers are filled in Column F.

I would now like to highlight each cell in my range (B1:D4) that won.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]13[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"][/TD]
[TD="align: center"]21[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"][/TD]
[TD="align: center"]23[/TD]
[/TR]
</tbody>[/TABLE]

 

[tjtoad2]

Anyone have any ideas for a conditional formatting formula to address this? Thanks.

 

[Fluff]

Select B2:D4 & use
=isnumber(match(B2,$F$1:$F$4,0))