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.

An example inspection log highlights only the ID cells in A2:A5 as the rule range.

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.

Two highlighted C-17 inspections have different dates, with the other IDs left unmarked.

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.