With ActiveWorkbook.Styles('Flashing').Font Now create the macros (there are two of them), as follows: With the style now defined, you need to apply that style to any cells you want to 'flash.' Make sure you don't apply the style to any other cells. Excel displays selections of pre-defined styles.
In the Styles group, click Cell Styles.Make sure the Home tab is displayed on the ribbon.(Make sure the cell has something in it it should not be blank.)
To create the special style, follow these steps: By utilizing these tools, you can make cells blink by first designing a special style for the blinking cells, and then running a simple macro. For such a feat, you are left to your own devices and the miracle of macros. What is missing, however, is a way to make the contents of a cell flash, or blink on and off. For instance, a cell might be formatted so that its contents are displayed in red or in boldface if above or below a certain threshold. Many people use the conditional formatting features of Excel to draw attention to specific values or areas of their worksheets.