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.
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.
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.
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.
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.
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.
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
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