Cart C-17 appears twice in the inspection log. The visits may both be valid. Highlight the repeated ID cells while keeping the dates and outcomes available for review.
Apply the rule to the ID cells
In a test sheet, enter C-17, C-42, C-17 and C-31 in A2:A5. Select just A2:A5. In Ulet Sheets, open Home > Conditional Formatting and create a Duplicate Values rule. Confirm the range and choose a style you can read on the sheet.

Example range. Keep the heading and visit details outside the duplicate rule.
Check both visits and test a change
The C-17 cells should be highlighted. Look across both rows at the dates and outcomes. In this example, the checks took place on different days. In a working copy, change the second C-17 to C-19. Both former matches should lose the duplicate styling.

Example result. Compare both visit records before changing the data.
Restore the test value, save and reopen the XLSX. Confirm the rule still marks the two matches. If another row is appended below A5, check whether the applied range now needs to include it.



