Paul Wherly

Conditional Formatting in Excel

Conditional Formatting in Excel 2016

Imagine the scene. You have some figures to present to your team, or it could be the monthly sales meeting. Or you could be persuading an investor that you are a great investment. You have the figures but they look a bit boring. How can you jazz them up and make them stand out especially for those of your audience who see in pictures and colours rather than numbers. Here is where Conditional Formatting comes into its own.

There are several types of Conditional Formatting and in this blog I am going to show you how to format the top 10 in a list of numbers. The numbers you will see represent sales of coffee and we need to make them stand out. You will also learn how to highlight just the cells whose value is greater than 1000.00.

Now that you can see how to start playing with Conditional Formatting, have a go at some of the other formats. Look out for more tips from me at The IT Training Surgery on the other types of Conditional Formatting.

Till next time



To learn about Excel 2016 or indeed any other version including Excel on the Mac, give us a call on 020 8203 1774 and find out how we can help your organisation get better results.

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.