Hello all,
I have a vehicle register that has renewal dates to which I wish to be alerted with the cell turning red one month prior to date, I have done this before but can't remember how I did it. can anyone advise. Thanks
Hello all,
I have a vehicle register that has renewal dates to which I wish to be alerted with the cell turning red one month prior to date, I have done this before but can't remember how I did it. can anyone advise. Thanks
Hi and welcome to the forum
You need conditional formatting for this...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A2<=today()-30 format fill as needed
This assumes your data is in A2 - adjust as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you FD
I will give it a go, Cheers
Excellent, worked perfectly, Many Thanks
Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
Hi,
Well I thought it did, but unfortunately it didn't, if I use that formula in another cell it will highlight, but if I use the data cell it should be it doesn't ?? Any other suggestions please ?
oops left off the $...
=$A2<=today()-30
Still a NO GO
Is this thread still open, or have you managed to get it to work?
Regards
Alastair
=C6<(TODAY()+30) is the formula I came up with that has worked.
Thank you, you mat close this one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks