Highlight Entire Row In Excel Based On One Cell

A NEW VERSION OF THIS POST HAS BEEN PUBLISHED HERE: http://easy-excel.com/?p=337 Do you want to highlight the entire row in your Excel report based on the value of one of the cells in the row? There is an easy way to do this in Excel: Conditional Formatting. It’s easy, and it only takes 3 minutes! … Continue reading →

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 →

Boolean logic in Excel: TRUE/FALSE instead of IF functions

A new version of this article has been published here: http://easy-excel.com/?p=638 Why use the IF function when there is an easier way to do it? If you’re looking for a TRUE or FALSE answer, you don’t need it! Let’s use Boolean logic instead – it will save you a lot of time and struggle. Let’s look at an … Continue reading →