Conditional Formatting to match a group of numbers

**thewrathful** · 12-14-2009, 12:37 PM

Hey guys,

I am trying to make a group of numbers go coloured if they match any of the numbers in another section. I know single formatting where you can colour a cell if it matches 1 other number but this is a bit different.

Example attached

Thank you

**daddylonglegs** · 12-14-2009, 12:43 PM

So what's the rule in this case - I can't work it out from your example

**JBeaucaire** · 12-14-2009, 12:47 PM

If you simply want the groups to light up if each number exists anywhere in the other chart, do that like so:

1) Highlight A5:E13
2) Select Format > Conditional Formatting > Condition1: Formula Is: =COUNTIF($G$5:$K$13, A5)>0
3) Click Format... Patterns: RED
4) OK > OK

5) Highlight G5:K13
2) Select Format > Conditional Formatting > Condition1: Formula Is: =COUNTIF($A$5:$E$13, G5)>0
3) Click Format... Patterns: YELLOW
4) OK > OK