Filed under Conditional Formatting

Find Duplicates and Triplicates in Excel

A NEW VERSION OF THIS POST HAS BEEN PUBLISHED HERE: http://easy-excel.com/?p=503 Is there an easy way to highlight duplicates in a list in Excel? If you just want to remove duplicates, you can use the Advanced Filter or the built-in Remove Duplicates feature, but what if you want to keep the duplicates in the list and … Continue reading

Create a search field in Excel in 5 minutes

A NEW VERSION OF THIS POST HAS BEEN PUBLISHED HERE: http://easy-excel.com/?p=158 Is it possible to create a search field in Excel, without using VBA? Yes, and it’s easy! We will use Conditional Formatting to highlight the fields that match the search string. For example, if you look at the table below, we want to highlight row … Continue reading