LinkBack URL
About LinkBacks
Hi kennedy
Say your PRD date is in cell A1 then this formula in Conditional Formatting will change the colour of the cell when it is within 15 months of today's date :
=DATEDIF($A$1,NOW(),"m")<15
HTH
DominicB
Hi kennedy
Say your PRD date is in cell A1 then this formula in Conditional Formatting will change the colour of the cell when it is within 15 months of today's date :
=DATEDIF($A$1,NOW(),"m")<15
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks