software

Hi,

I need to know the blinking a value or cell is avail in Excel.

For example, if the value is gt;100, the value should blink.

Can anyone help?

Thx in adv.

-Sivassou.


Blinking is possible with VBA, but not with conditional formatting.
However, most users will agree that blinking is very annoying, and that
simply changing the background color to red (or similar) is just as
affective without the eye strain of a blinking cell.

Try the conditional formatting route and see if meets your needs.

Good luck.

Bruce--
swatsp0p------------------------------------------------------------------------
swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
View this thread: www.excelforum.com/showthread...hreadid=498252Thx Bruce....I got in Conditional formatting.

However, my customer requirement is 'to blink...'

By the way, Can I have a VBA code and how to do that.

Plz.

-Sivassou.

quot;swatsp0pquot; wrote:

gt;
gt; Blinking is possible with VBA, but not with conditional formatting.
gt; However, most users will agree that blinking is very annoying, and that
gt; simply changing the background color to red (or similar) is just as
gt; affective without the eye strain of a blinking cell.
gt;
gt; Try the conditional formatting route and see if meets your needs.
gt;
gt; Good luck.
gt;
gt; Bruce
gt;
gt;
gt; --
gt; swatsp0p
gt;
gt;
gt; ------------------------------------------------------------------------
gt; swatsp0p's Profile: www.excelforum.com/member.php...oamp;userid=15101
gt; View this thread: www.excelforum.com/showthread...hreadid=498252
gt;
gt;

See:

www.cpearson.com/excel/BlinkingText.htm--

Regards,

Peo Sjoblom

quot;Sivassouquot; gt; wrote in message
...
gt; Thx Bruce....I got in Conditional formatting.
gt;
gt; However, my customer requirement is 'to blink...'
gt;
gt; By the way, Can I have a VBA code and how to do that.
gt;
gt; Plz.
gt;
gt; -Sivassou.
gt;
gt; quot;swatsp0pquot; wrote:
gt;
gt; gt;
gt; gt; Blinking is possible with VBA, but not with conditional formatting.
gt; gt; However, most users will agree that blinking is very annoying, and that
gt; gt; simply changing the background color to red (or similar) is just as
gt; gt; affective without the eye strain of a blinking cell.
gt; gt;
gt; gt; Try the conditional formatting route and see if meets your needs.
gt; gt;
gt; gt; Good luck.
gt; gt;
gt; gt; Bruce
gt; gt;
gt; gt;
gt; gt; --
gt; gt; swatsp0p
gt; gt;
gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; swatsp0p's Profile:
www.excelforum.com/member.php...oamp;userid=15101
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=498252
gt; gt;
gt; gt;