Do more with conditional formatting in Excel (part 1 of 2)

The conditional formatting tools got a big makeover in Excel 2007. Among the additions were:


  • The ability to have more than 3 conditions per cell (many more!)
  • The ability to colour code every cell with shades on a scale (for example from red to green) based on its value
  • The ability to add in-cell shading – like a mini bar chart – to add visual clues as to the relative value in that cell
  • The ability to add icons such as arrows and traffic lights to cells depending on their values

There were lots of other additions aimed at making existing capabilities easier to use – for example highlighting duplicate values in a range was always possible with conditional formatting, but now it only requires a couple of clicks.

But there are other things that are still only posible with a bit of know-how. And by the end of this video tutorial, you to can know-how!

Key conditional formatting tricks

Once you’ve watched our video you’ll know how to do the following:

  1. Make the conditional formatting more dynamic, by referencing a “threshold cell” in your condition. Change the condition simply by changing the value in that cell
  2. Make the entire row change colour when a single value in that cell meets the condition
  3. Use a scroll-bar control to change the value in a cell by dragging the scroll-bar.

Take a look at the video, and give us your feedback in the form below. And if you’d like to know more about what can be done with Excel, why not get in touch and organise some Excel training for you and your company?

Part 2 coming soon!

Come back later this week and in part two, we’ll take a look at how to use conditional formatting to make an on-screen form tailor itself to the answers you give!

Video length: 14m 13s
Excel version used: 2010
Tutorial specific to this version: No