Flashing cells in Excel 2010

Forum home » Topics » Flashing cells in Excel 2010

Flashing cells in Excel 2010

There are many reasons why someone may want to have cells flashing in Excel.

For example, suppose you are working to a very strict budget on your expenses account and wish to indicate by means of a flashing cell when the variance is either above or below a certain parameter. You would have to create some code in the Visual Basic Editor using either a Select Case statement or a For Next loop with If functions.

Set your parameters within the code and also the change to the interior colour (this usually works best) rather than the font colour. Changing from White to Red then back to White for negative results usually works well. For positive results, if required, starting from White then to Green then back to White does a great job.

Remember when using the word 'colour' in the code you must use the American spelling of 'color'.

Related articles

How To Use Conditional Formatting In Excel

Conditional formatting in Excel is an extremely useful tool, enabling the user to quickly and easily create a visual impression of the data. A user can add coloured icons or data bars to cells to show performance in relation to other cells or via rules. This article explores conditional formatting.

Read article



Training courses


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Server loaded in 0.07 secs.