Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
garygadget
 
Posts: n/a
Default How to Blink a cell in Excel if negative or red colour

Is it possible to make cells that become negative on calculation or red in
colour to Blink.

I have a summary sheet that totals calculates from several others. The cells
turn negative and red when calculating a deficit.

I would also like them to blink
Please advise in not to tech terms how I may achieve this.

Many thanks
garyB

  #2   Report Post  
greg7468
 
Posts: n/a
Default


Gary,

search for Blinking cells there are lots of posts on this topic.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=381169

  #3   Report Post  
greg7468
 
Posts: n/a
Default


Gary, from previous posts on this topic, you may find this will help you
out,

http://snipurl.com/cpo7

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=381169

  #4   Report Post  
Barb R.
 
Posts: n/a
Default

How about using conditional formatting for this one. Blinking can cause
issues for epileptics (as I recently was told). Go to format - Conditional
formatting when you've selected the cell you want to format.

"garygadget" wrote:

Is it possible to make cells that become negative on calculation or red in
colour to Blink.

I have a summary sheet that totals calculates from several others. The cells
turn negative and red when calculating a deficit.

I would also like them to blink
Please advise in not to tech terms how I may achieve this.

Many thanks
garyB

Reply
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
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
display negative values as a blank cell in Excel Pheroze Bharucha Excel Discussion (Misc queries) 0 January 4th 05 10:51 PM
Excel: how to formulate conditional cell references centraloffice Excel Worksheet Functions 1 December 10th 04 08:57 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 09:01 PM.

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

About Us

"It's about Microsoft Excel"