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.