Lottery Checker Conditional Formatting

[Mathew]

Good Afternoon All,

Conditional Formatting question again! I have searched the other posts &
replies but found nothing that I could use or cobble together.

This code is to colour cells if they match one of 6 cells in a range.


A B C D E F
1 1 2 3 4 5 6 Lottery Result
2
3 2 4 5 6 8 9 Numbers Chosen

So in this case I wish A3, B3, C3 & D3 to colour yellow as they match the
numbers drawn in row 1


I hope I have expalined this okay.
As usual grateful thanks for any assistance

Cheers

Mathew

 

[Don Guillett]

See if this helps
=SUMPRODUCT(($B$5:$G$5=F6)*1)

 

[DeveloperX]

Good Afternoon All,

Conditional Formatting question again! I have searched the other posts &
replies but found nothing that I could use or cobble together.

This code is to colour cells if they match one of 6 cells in a range.

        A    B    C    D    E    F
1        1    2    3    4    5    6        Lottery Result
2
3        2    4    5    6    8    9        Numbers Chosen

So in this case I wish A3, B3, C3 & D3 to colour yellow as they match the
numbers drawn in row 1

I hope I have expalined this okay.
As usual grateful thanks for any assistance

Cheers

Mathew

Select the cells A3 through F3.
set the formula to in the conditional formatting to
=IF(ISERROR(HLOOKUP(A3,A1:F1,1,FALSE)),FALSE,TRUE)

 

[RyanH]

Put this under Conditional Formatting:

Cell Equals then "=MATCH(A3,$A$1:$F$1,0)" then select the Fill color to be
Yellow

Make sure you drag cell A3 to F3 to copy the conditional formatting

Hope this helps! If so, please click "Yes" below.

 

[PCLIVE]

You could use this in conditional formatting in A3.

Formula Is:
=COUNTIF($A$1:$F$1,A3)>0

Copy A3 and paste special, Formats to the other cells needed.

HTH,
Paul

 

[Mathew]

Thanks Guys, I forgot about SUMPRODUCT & MATCH
And no VBA!
Cheers again

Mathew