Question

A junior data analyst needs to search their spreadsheet for a particular client ID. In order to identify all cells containing the ID, they use a spreadsheet tool that changes how cells appear when values meet specific conditions. What tool do they use?

Answer 1

Conditional formatting — it applies formatting rules (e.g., highlight cells equal to that client ID) so all matching cells are visually flagged.