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 ...

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 ...

Conditional formatting is powerful, but you can avoid frustration by learning how and when Excel evaluates rules. The interface isn’t particularly intuitive, but it does allow you to edit rules ...

We’ll use a conditional formatting rule to highlight values equal to or less than 21. To get started, select the data you want to format in Excel, in this case, that’s C3:F6 and do the following: ...

We looked at using conditional formatting to present data in the first article in this tutorial series. This time we are going to build on a technique I first saw in a presentation by Bob Phillips at ...