- In short
- Highlights values that appear only once in the selected cells. Values are not changed and the operation can be undone. Colored unique cells. Your source data stays unchanged and can be reversed in one step with Undo Last. Everything runs on your computer, with no internet involved.
What it is for
Highlight Unique Values is used to highlight values that appear exactly once.
When to use it
It earns its place whenever you have to visually find one-off records.
Example scenarios
- Visually find one-off records.
What it needs
A range ≥2 cells and an options dialog. Supported data types: text, number, date (by selection).
How to use it
- Select the range to compare.
- Run Highlight Unique Values from the Compare & Check group on the XLMind Plus tab.
- Pick the settings you need in the window that opens.
- Confirm; colored unique cells.
What it produces
Colored unique cells.
Effect on your data and undo
Highlight Unique Values writes the result over the cells you selected. One click on Undo Last brings everything back.
How it differs from similar tools
It applies a one-off, lasting mark without setting up conditional formatting rules; there is nothing to maintain and one step undoes it.
Good to know
Size limits (≥2 cells + DedupeOptionsDialog.).
Limitations
Size limits (≥2 cells + DedupeOptionsDialog.).
Frequently asked questions
- Where is the output written?
- Colored unique cells.
- What happens to invalid or unexpected values?
- Codes not parsed.
- Does the result stay linked to the source?
- What you get is static: it will not follow later edits, so rerun the tool once the data moves on.
- Any known limits?
- Size limits (≥2 cells + DedupeOptionsDialog.).
Works well with
- To tidy the data first, use Highlight Duplicates
- As a next step, use Add Duplicate Count
- A good companion is Compare Two Lists
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.