Image here of what I'm trying to do, for a lottery spreadsheet:
If a number in the "Numbers Played" row shows up in the "Winning Numbers" section on the right, in the same row, I need it to highlight that number.
I thought I had it working, but in the 4th row, in the "Winning Numbers" section there is a 19, and there is also a 19 in the "Numbers Played" section, but it's not highlighting.
How can I get the "Numbers Played" row to highlight a number, if that number is in the same row on the right, in the "Winning Numbers" section?
If a number in the "Numbers Played" row shows up in the "Winning Numbers" section on the right, in the same row, I need it to highlight that number.
I thought I had it working, but in the 4th row, in the "Winning Numbers" section there is a 19, and there is also a 19 in the "Numbers Played" section, but it's not highlighting.
How can I get the "Numbers Played" row to highlight a number, if that number is in the same row on the right, in the "Winning Numbers" section?