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