View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vvaidya@pol.net is offline
external usenet poster
 
Posts: 24
Default 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