ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Blink a cell in Excel if negative or red colour (https://www.excelbanter.com/excel-discussion-misc-queries/31841-how-blink-cell-excel-if-negative-red-colour.html)

garygadget

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


greg7468


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


greg7468


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


Barb R.

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



All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com