I have 2 worksheets. One has locations with numbers, example:

275 Location 1

276 Location 2

I have all my locations on the second sheet, but in 2 different columns, listed with numbers only, example:

271 275

272 300

I have 2 scenarios I need help with.

1st:

If any of the numbers on sheet 1 match the numbers in column 1 on sheet 2, highlight the number on sheet 1 in green

If any of the numbers on sheet 1 match the numbers in column 2 on sheet 2, highlight the number on sheet 1 in red

2nd:

If the number on sheet 2 matches any number on sheet 1, highlight green

I want these to apply to all the cells that have numbers (it could apply to all cells I guess as it should ignore it if it doesn't match, I would assume)

275 Location 1

276 Location 2

I have all my locations on the second sheet, but in 2 different columns, listed with numbers only, example:

271 275

272 300

I have 2 scenarios I need help with.

1st:

If any of the numbers on sheet 1 match the numbers in column 1 on sheet 2, highlight the number on sheet 1 in green

If any of the numbers on sheet 1 match the numbers in column 2 on sheet 2, highlight the number on sheet 1 in red

2nd:

If the number on sheet 2 matches any number on sheet 1, highlight green

I want these to apply to all the cells that have numbers (it could apply to all cells I guess as it should ignore it if it doesn't match, I would assume)

## Comment