How to Use Excel to Interpolate. Interpolation is a powerful tool used to determine values that do not appear within a given set of numbers.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.