Google Sheets Conditional Formatting Expert

Job ID: 39277009

Budget: $10 – $30 AUD

I'm looking for an expert in Google Sheets who can help me with conditional formatting based on specific text matches. I would like a formula that when one cell is selected, any other cell in the sheet with that same text is highlighted.

Key Requirements:
- Expertise in Google Sheets
- Proven experience with conditional formatting
- Ability to apply text-based conditions

I have a set of codes in the corner of the sheet - when one is clicked I would like any other exact match of that code in the sheet to highlight.