The browser supports conditional formatting; however, you can’t use the browser to implement a formula rule. How to highlight individual values in Excel The simple data set shown in Figure A ...

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. ... or use a shape or ratings icon to flag all duplicate values above 12,000.

When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.