![]() |
Blink specific data in excel
I have a list of products with their Expirty Date. I want when expiry date
near the current system date, a message blink on my desktop with list of expiry date of products. |
Blink specific data in excel
you will have to write a macro that checks the expiry dates with the system
date and flash a message. You can set this macro to run at a specific interval or on opening the workbook etc. Regards, Pranav Vaidya "Shafiq" wrote: I have a list of products with their Expirty Date. I want when expiry date near the current system date, a message blink on my desktop with list of expiry date of products. |
Blink specific data in excel
Check out Chip Pearson's site:
http://cpearson.com/excel/BlinkingText.htm Shafiq wrote: I have a list of products with their Expirty Date. I want when expiry date near the current system date, a message blink on my desktop with list of expiry date of products. -- Dave Peterson |
Blink specific data in excel
Blinking text is not advised, but if you have your heart set on it
then follow this link: http://www.cpearson.com/excel/BlinkingText.htm Alternatively, you could apply a conditional format to highlight the Expiry Date as it nears the system date. Hope this helps. Pete On Jul 5, 6:10 am, Shafiq wrote: I have a list of products with their Expirty Date. I want when expiry date near the current system date, a message blink on my desktop with list of expiry date of products. |
All times are GMT +1. The time now is 09:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com