I have a list of dates in excel and i was wondering if there was a way i can make a cell blink or just change the color of the cell if the date is within 7 days of the current date.
I have a list of dates in excel and i was wondering if there was a way i can make a cell blink or just change the color of the cell if the date is within 7 days of the current date.
Select cell and go to Format|Conditional Formatting
Select Formula Is from 1st drop down and enter =AND(B12>TODAY(),B12<TODAY()+7)
where B12 is the cell containing the date...adjust as necessary...
click Format and go to Pattern tab to select colour...
click Ok
Click Ok to finish..
This assumes you mean within 7 days into the future from today
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks