Conditional Formatting is the practice of formatting cells in Excel spreadsheets to change cell appearance depending on certain conditions.

It can be extremely useful for immediately highlighting certain parts of a spreadsheet so that your attention is drawn to them – for example when a value goes over a certain threshold, or a date passes its deadline.

In this tutorial we’ll show you how to use conditional formatting to change the colour of cells depending on a percentage.

Why not check out our Top 10 Excel Time Saving Formulas for more helpful tips. 

Conditional Formatting Tutorial – Colour Coded Data

Here’s our example data. We’ve used the 2011 market share figures for smart phone operating systems worldwide.

Read the rest of “Conditional Formatting Tutorial – Excel 2007 & 2010″