I would like to be able to create condition formats for my entire file to highlight dates that have passed 3 years, 2 years, etc. I understand that there is a simple preset conditional format to highlight dates that have passed several weeks ago, but that is short of the duration I need. I tried to use this conditional format and to look up the coding and adjust the time but I was not able to find that code.
Thank you in advanced for your help.
Last edited by smurf54454; 08-13-2019 at 09:14 AM.
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Select B5:B28
Formula for CF
RED
=TODAY()>DATE(YEAR(B5)+3,MONTH(B5),DAY(B5))
YELLOW
=TODAY()>DATE(YEAR(B5)+2,MONTH(B5),DAY(B5))
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you!
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks