In this article, I’ll show you two ways to highlight unique values using conditional formatting. First, we’ll review the easy way: Using a built-in rule that highlights the individual value.

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.