For this first part of the series we are going to revisit some data we looked at almost exactly three years ago in a previous KPI reporting tutorial: Here we used the conditional formatting in Excel ...

If you want to copy the conditional format to a range of cells you need to do the following: In Excel, conditional formatting is considered part of the regular formatting of a cell. If you want to ...

Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.

Excel 2007 introduced built-in icons for conditional formatting, if you wanted to achieve a similar result in Excel 2003 you had to create the icon and conditional format manually. We can achieve this ...

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.