Conditional formatting to match row numbers

[mtouhig]

Hi - I am setting up a spreadsheet based on the lottery bonus balls drawn each Saturday. I have a list of 30+ people, each of which have chosen 6 numbers. I am trying to format the cells of any of the numbers they have chosen if they match a one row range of numbers (these are the bonus balls drawn each week and increases weekly). Basically, if any of a players number is drawn, that particular cell would be formatted accordingly.

Thanks all for any help or advice

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.