Lottery Checker Conditional Formatting

  • Thread starter Thread starter Mathew
  • Start date Start date
M

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
 
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
Click to expand...

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)
 
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.
 
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
 
Back
Top