How to Highlight Duplicate IDs in Excel

Open your Excel workbook (.xlsx) in Cue Office and apply the Duplicate Values conditional formatting rule to the ID column. When the same nonblank ID appears at least twice, the rule highlights every occurrence. Your original records and leading zeros stay intact.

Highlight duplicates only in the ID column

In the repair register, locate Ticket ID (column A). Click Home → Conditional Formatting on the top ribbon to open the side panel, then click the plus sign next to Rules to create a new rule.

Rules list, add button, and duplicate values rule for A2:A9 in the Conditional Formatting panel
The plus button next to Rules creates a new rule. The rule applied to A2:A9 is listed below.

Click the range selector to the right of Apply Range, enter A2:A9, and click Confirm. Starting at A2 skips the table header. Selecting only the ID column prevents repeated item names and intake desks from being flagged as duplicates.

Set Style Type to Highlight Cell and Style Rule to Duplicate Values. Choose your preferred highlight color, then click Submit to apply the rule.

Conditional formatting rule editor showing A2:A9, Highlight Cell, Duplicate Values, and Submit
Before submitting, confirm that the range is A2:A9 and the rule is set to Duplicate Values.

How to verify the correct IDs are highlighted

Click Save and reopen the workbook. If configured correctly, the duplicate values 0042 and 0047 are each highlighted twice, showing four blue cells in total. The two blank ID cells and the unique values 0051 and 0060 are not highlighted. Click the image to open the full register to inspect the Reported fault column on the right and compare the multiple records sharing each ID.

Blue highlights on Ticket IDs in rows 2, 3, 4, and 7
Blue-highlighted IDs appear in rows 2, 3, 4, and 7. Click the image to view the full register.

This rule evaluates cells up to A9. If you add tickets in row 10 or beyond, expand the Apply Range to include the new rows so those IDs are checked as well.

How to ask Cue AI to set a rule that skips blank IDs

To explicitly define how blank cells are handled, you can prompt Cue AI to write a conditional formatting rule that colors only nonblank IDs appearing more than once. In a copy of your original register, open Cue AI and send the following prompt.

In the Repair Register worksheet of this workbook, apply a conditional formatting rule to A2:A9 that highlights every repeated nonblank Ticket ID in a light red fill. Exclude blanks, preserve leading zeros and all original cells, and leave unique IDs unformatted. Please apply the rule to the workbook so the highlight updates when a ticket ID changes; do not just describe the steps. If you cannot apply a conditional formatting rule, tell me so without changing the workbook.
Cue AI panel showing the beginning of the conditional formatting request
Submit your request in Cue AI, specifying the worksheet and ID range.

Save and reopen the workbook copy, then check column A. Both instances of 0042 and 0047 have a red fill, leading zeros remain intact, and neither blank cell is highlighted.

Both instances of 0042 and 0047 highlighted with a red fill after reopening the workbook
After Cue AI applies the rule and you reopen the workbook, the red fill appears only in column A.

To confirm that highlighting updates dynamically, change A4 from 0042 to R-0099 in the copy. Because the IDs in A2 and A4 now appear only once each, both cells lose their red fill. 0047 still appears twice and remains highlighted.

A2 and A4 lose red fill after changing A4 to R-0099, while 0047 remains highlighted
After editing A4, only the two instances of 0047 remain highlighted in red.

Practice with the repair register

View full practice dataset

A community repair desk uses this table to log repair orders. When practicing, keep ticket IDs stored as text and make sure A2 displays 0042 after entry.

Ticket ID	Item	Reported fault	Desk
0042	Desk lamp	Loose switch	A
0047	Toaster	Lever sticks	B
0042	Desk lamp	Switch recheck	A
	Radio	Intake pending	B
0051	Fan	Noisy motor	A
0047	Toaster	Second intake	B
	Kettle	Intake pending	A
0060	Clock	Loses time	B
Eight repair records before highlighting, showing IDs, items, faults, and desks
The original register contains eight records, with leading zeros preserved in the Ticket ID column.

Follow up with each desk on missing IDs

After checking the duplicate IDs, ask Cue AI to count tickets by Desk where the item is filled in but the ticket ID is blank. Check the result against the register: the radio at Desk B and the kettle at Desk A each need an ID, so the count should be one for each desk.

Open the original PDF (.pdf) repair slips in Cue Office and match each item and fault before filling in the missing IDs in the Excel register (.xlsx). If the next shift needs to follow up, ask Cue AI to draft a Word (.docx) handoff with both items, or use the records in a PowerPoint (.pptx) training slide to show how to fill in missing IDs. Cue Office can open the PDFs and edit the Word, Excel, and PowerPoint files for free. Download Cue Office for free