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

Earlier this week, in part one of this Microsoft Excel video tutorial, we looked at making conditional formatting more dynamic. We showed you how to highlight an entire row of data when a value was met in one cell of that row. We also looked at adding a scroll bar to the worksheet so that you could change a value in a cell simply by dragging to the left or right.

In this video, we take a look at using conditional formatting to enable a form to be made dynamic.

This means that the form adapts itself to the answers given by the user. For example, if a user says they have three children, the form prompts the names and ages of those children. If the user says they have a food intolerance, the form is able to prompt them dynamically for details about that intolerance.

As with the last video, this doesn’t rely on you having the latest and greatest version of Excel. The video itself is created using Excel 2010, but the tip will even work in Excel 97.

So, take a look and see what you think. If you think it might be useful to you then great! Why not share your story with us using the form below?

And if you’d like to spend some time with us – either one-to-one, or with colleagues from your company – then of course we’d be delighted to see you. Just get in touch using the contact form on any page of this website.

Video length: 17m 50s
Excel version used: 2010
Tutorial specific to this version: No