Microsoft Office Forums Conditional Formatting

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-25-2014, 03:03 PM
jdc15371 jdc15371 is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 64bit
Novice
Conditional Formatting
 
Join Date: Dec 2013
Posts: 12
jdc15371 is on a distinguished road
Default Conditional Formatting

If the value in cell D10 is greater than 100, the in Cell E10 I want "Exception" printed in Red and I want Exception to continuously blink off and on.



In Lotus 123 this could be done (i.e., the word Exception to blink)

Question:

Is there a way in Excel 2013 to make the value in Cell E10 blink off and on? If so, please explain how.

Thank you
Reply With Quote
  #2  
Old 06-26-2014, 12:13 AM
macropod's Avatar
macropod macropod is offline Conditional Formatting Windows 7 32bit Conditional Formatting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,483
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by jdc15371 View Post
If the value in cell D10 is greater than 100, the in Cell E10 I want "Exception" printed in Red and I want Exception to continuously blink off and on.
Not in Excel. Conditional formatting applies a static format. If you want anything else, you'll need a macro. And any macro you might use for this will seriously compromise Excel's ability to do simple things like cut & paste.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 06-26-2014, 06:34 AM
jdc15371 jdc15371 is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 64bit
Novice
Conditional Formatting
 
Join Date: Dec 2013
Posts: 12
jdc15371 is on a distinguished road
Default Thanks

Paul: Thanks for your help. Gee, I wish I could remember how LOTUS did it. I remember that it was a simple task.
Reply With Quote
Reply

Tags
blinking cells

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting otuatail Excel 1 06-06-2012 05:07 AM
Conditional Formatting Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Conditional Formatting Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM
Conditional Formatting help with conditional formatting Snvlsfoal Excel 3 07-03-2011 11:55 PM


All times are GMT -7. The time now is 07:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft