Flashing message in cell (alternate font and background colors)

[vvaidya]

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

 

[Tom Ogilvy]

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