Tote: If recogniser and cells matching change colour

[Jones90]

Hi,

I'm trying to set up a Tote for my local sports clubs, basically I need to identify if members numbers match drawn numbers. If they do I want the cells to turn green, if they don't I want the cells to turn red.

I also want a cell at the end to identify how many numbers they have matched and then give a result of winning or not.

I have attached the spreadsheet of how the result should look like.

Any help appreciated as always
Thanks

[AliGW]

So, your conditional formatting rules for C18 (untested):

=MATCH(C18,$C$1:$F$1,0) (this is for green)

=ISNA(MATCH(C18,$C$1:$F$1,0)) (this is for red)

And the counting formula:

=SUMPRODUCT(COUNTIF(C18:F18,$C$1:$F$1))

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Jones90]

Brilliant, all solved.

Thank you

[AliGW]

Glad to help - thanks for the rep.