New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

blink cell excel when date is near

Macros, VBA, Excel Automation, etc.

blink cell excel when date is near

Postby EmyvilleRL » Tue Dec 13, 2011 10:43 pm

I want to make a blink cell excel when date is near eg due date is 15/12/2011

I want the excel cell to start blinking 3 days to the date and turn red on 15/12/2011

Please help me solve this problem
  • 0

EmyvilleRL
Rookie
 
Posts: 1
Joined: Dec 13, 2011
Reputation: 0

Re: blink cell excel when date is near

Postby Don » Wed Dec 14, 2011 12:39 am

Have you tried using conditional formatting? You might not get the exact blinking affect, but you could have the cell change to yellow a few days before and then red on the due date. This wouldn't require any macros or vba to do and would be easier to maintain/change in the future.
  • 0

Don
Moderator
 
Posts: 733
Joined: Dec 4, 2011
Reputation: 2
Excel Version: 2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 43 guests

cron