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(a110,"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

Flashing message in cell (alternate font and background colors)
 

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


wrote in message
oups.com...
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(a110,"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