One of the most common requests I receive from users is how to identify duplicate and unique values in Microsoft Excel. The easiest way I know is to apply a conditional format. In a nutshell, a ...

How to use a conditional format to highlight subtotal rows in Excel Your email has been sent If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting ...

Alternating row or column colors assists data identification by making the row or column easier to distinguish. In Microsoft Excel, you can achieve this effect using conditional formatting to change ...

Paste Special is an underrated tool in Microsoft Excel, with many people only using it to paste values. But it can do much more than that! Whether this is the first time you've heard of Paste Special ...