ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Formating (https://www.excelbanter.com/excel-discussion-misc-queries/39922-cell-formating.html)

Hecwill

Cell Formating
 
How to make a cell twinks when a condition is met in excel ?

Earl Kiosterud

Hecwill,

You've probably seen blinking formatting in Word. Excel has no such
formatting. It's possible, though not recommended to use timed macros to
do this. It works by changing the formatting periodically.
--
Earl Kiosterud
www.smokeylake.com

"Hecwill" wrote in message
...
How to make a cell twinks when a condition is met in excel ?




Doug Kanter

Why is it not recommended?

"Earl Kiosterud" wrote in message
...
Hecwill,

You've probably seen blinking formatting in Word. Excel has no such
formatting. It's possible, though not recommended to use timed macros to
do this. It works by changing the formatting periodically.
--
Earl Kiosterud
www.smokeylake.com

"Hecwill" wrote in message
...
How to make a cell twinks when a condition is met in excel ?






Dave Peterson

You'd have to use some kind of procedure that runs every second or two.
Personally, I think that this would be a resource hog (as well as just
irritating to the eye).

But there are lots of solutions archived on google that do just that.

Doug Kanter wrote:

Why is it not recommended?

"Earl Kiosterud" wrote in message
...
Hecwill,

You've probably seen blinking formatting in Word. Excel has no such
formatting. It's possible, though not recommended to use timed macros to
do this. It works by changing the formatting periodically.
--
Earl Kiosterud
www.smokeylake.com

"Hecwill" wrote in message
...
How to make a cell twinks when a condition is met in excel ?




--

Dave Peterson

Bob Phillips

Never mind the resource hog, it is simply intrusive, and is bad style
design.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dave Peterson" wrote in message
...
You'd have to use some kind of procedure that runs every second or two.
Personally, I think that this would be a resource hog (as well as just
irritating to the eye).

But there are lots of solutions archived on google that do just that.

Doug Kanter wrote:

Why is it not recommended?

"Earl Kiosterud" wrote in message
...
Hecwill,

You've probably seen blinking formatting in Word. Excel has no such
formatting. It's possible, though not recommended to use timed

macros to
do this. It works by changing the formatting periodically.
--
Earl Kiosterud
www.smokeylake.com

"Hecwill" wrote in message
...
How to make a cell twinks when a condition is met in excel ?



--

Dave Peterson





All times are GMT +1. The time now is 08:49 AM.

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