ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   blinking negative number (https://www.excelbanter.com/excel-discussion-misc-queries/224433-blinking-negative-number.html)

GD

blinking negative number
 
Can I make a negative number blink in excel

Luke M

blinking negative number
 
I seem to recall that there's a way to mimic this using VBA, but I'm afraid I
don't recall the title of the thread.

If you were looking for a simpler answer, I'm afraid there isn't a
font/conditional format that does this.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"GD" wrote:

Can I make a negative number blink in excel


Gary''s Student

blinking negative number
 
see:
http://www.dailydoseofexcel.com/arch...linking-cells/
or
http://www.cpearson.com/excel/BlinkingText.aspx
--
Gary''s Student - gsnu200839


"GD" wrote:

Can I make a negative number blink in excel


Shane Devenshire

blinking negative number
 
Hi,

To clarify, Excel doesn't have this as a built-in feature. You need to use
one of the VBA solutions. FYI - Word had a feature for allowing blinking
text backgrounds, but they have taken it out in 2007. It wouldn't have done
you any good anyway because bringing it into Excel it stops blinking.

If you imbed a Word object which has blinking text (or other special effects
enhancements) you can see it in Excel by double-clicking the object (but in
reality you are now in Word, in Excel)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"GD" wrote:

Can I make a negative number blink in excel


hungayun

blinking negative number
 


"GD" wrote:

Can I make a negative number blink in excel


hungayun

blinking negative number
 


I think you use the symbol :"-" before numbers


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

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