Flashing message in cell (alternate font and background colors)

Hello:
I would appreciate help with the following.
I am trying to display a message (for example: "ALERT !") in cell B1,
IF user enters a value in cell A1 which is greater than say 10.
(Formula in B1 is: =if(a1>10,"ALERT!","")

Is there any way with VBA code that I can display this message to be
flashing, for example alternate between say red font with white
background and white font on red background?

Would appreciate you help
TIA
Vinay

Yes, just change the formatting periodically using the ontime method

See Chip Pearson's page on Ontime
http://www.cpearson.com/excel/ontime.htm

But have you looked at data validation

--
Regards,
Tom Ogilvy


<[email protected]> wrote in message
news:[email protected]...
> Hello:
> I would appreciate help with the following.
> I am trying to display a message (for example: "ALERT !") in cell B1,
> IF user enters a value in cell A1 which is greater than say 10.
> (Formula in B1 is: =if(a1>10,"ALERT!","")
>
> Is there any way with VBA code that I can display this message to be
> flashing, for example alternate between say red font with white
> background and white font on red background?
>
> Would appreciate you help
> TIA
> Vinay
>