Help with Google Sheets

Job ID: 36175272

Budget: $10 – $30 AUD

Hi,

Ideally need some help to write a formula that works in Google Sheets that does this. I am unsure which one is possible within the features of Sheets.

1. Multiple values match (ie Team 1, Team 2, Team 3) and listed as cell values (ie A1, A2, A3) and highlighted.

or, if unable to write #1

2. Multiple values match and highlighted only.
Related categories: Data Processing Excel Mathematics