Example Conditional Formatting

What is conditional formatting in Excel?  …and why should I use it?

Conditional formatting is a simple way to assign automatic formats to an individual cell or range of cells.  As the name suggests the function allows users to assign conditions to a cell that will then determine the format of the cell.  This means that cells will be automatically formatted as a cell value changes. 

 

There are several preloaded conditional formats available on the conditional format menu.  By running down the formats available the cell currently selected in your spreadsheet will change to show the format.  More than one format can be assigned to a cell.  The preloaded formats can also be edited.

cond_format.png

The example below shows a simple ‘traffic light’ conditional format for variances and the option to amend the preloaded settings under manage rules.

cond_format2.png

I hope you find this post useful. 

Darren