ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Flashing highlighter (https://www.excelbanter.com/excel-programming/387086-flashing-highlighter.html)

joseph robert

Flashing highlighter
 
What formula would anybody use in excel 2003 to assign a cell or scattered
cells in a worksheet a flashing color (preferably yellow highlighter)?

Gord Dibben

Flashing highlighter
 
You cannot use a formula to flash a cell.

You need VBA code.

See Chip Pearson's site for code.

http://www.cpearson.com/excel/BlinkingText.htm

If used properly and often you will be able to annoy many people.

Good luck.


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 10:56:02 -0700, joseph robert
wrote:

What formula would anybody use in excel 2003 to assign a cell or scattered
cells in a worksheet a flashing color (preferably yellow highlighter)?



joseph robert

Flashing highlighter
 


"Gord Dibben" wrote:

You cannot use a formula to flash a cell.

You need VBA code.

See Chip Pearson's site for code.

http://www.cpearson.com/excel/BlinkingText.htm

If used properly and often you will be able to annoy many people.

Good luck.


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 10:56:02 -0700, joseph robert
wrote:

What formula would anybody use in excel 2003 to assign a cell or scattered
cells in a worksheet a flashing color (preferably yellow highlighter)?



Thank you Gord, at least this will get the attention on people with
past-due accounts.



All times are GMT +1. The time now is 11:47 AM.

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