LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you alternate background colors by gridline? Mikey Charts and Charting in Excel 1 April 1st 08 06:13 PM
Background and font colors are not displaying in EXCEL 2003. Vermonter-in-Québec Excel Discussion (Misc queries) 2 January 16th 08 02:10 PM
Lost highlighting and font colors; background colors on web pages Jan in Raleigh Excel Discussion (Misc queries) 2 July 31st 07 09:10 PM
Alternate Background-colors sissi Excel Discussion (Misc queries) 1 August 21st 06 04:16 PM
Can't format font colors or cell fill-in colors canoeron Excel Discussion (Misc queries) 3 August 22nd 05 11:46 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"