On Course for Success

Conditional Formatting

Conditional Formatting in Excel

Help Focus the eyes with Conditional Formatting

Excel Conditional FormattingMicrosoft have made conditional formatting very easy with many preset formats. These are an ideal way to get started and will bring your spreadsheet to life and get the spreadsheet working for you. You can change the font and cell formatting based on the contents of cells. Many companies I have worked with use the Red, Amber and Green colours (traffic light system of colours). Red normally meaning some action needs to take place immediately, Amber showing that you need to keep an eye on the figures and Green is okay. There are so many ways that conditional formatting is used it would be impossible to list them all. If you sit at work changing colours to help highlight certain parts of your spreadsheet then you might find conditional formatting will save you time.

Remember to highlight the cells that you are going to conditionally format and then click the Conditional Formatting  command, from here you can make your choice from all the Microsoft presets or select New Rule to set your own rule and formatting/colours.

Most of the conditional formats are based on the contents of the cell being formatted; however, there is one choice where you can format cells based on other cells using a formula that is True or False.

Training or a course with this in is really useful as this really opens your Excel spreadsheet use and what you can get out of it.