09-06-2019 05:18 AM
09-12-2019 04:17 AM
Please find the attached with a conditional formatting applied to the range A2:A100 with the formula...
As per the formula, if there is a date in column A and once today's date is greater than the date 3 months after the date entered in column A, the date in column A would turn red with white and bold/italic font. In other words, the date in column A would turn red after 3 months.
Please refer to the attached for more details.
09-12-2019 04:44 AM - edited 09-12-2019 04:46 AM
The suggested conditional formula will do the dame thing.'
e.g. if the date you entered is 12/09/2019 (dd/mm/yyyy), it will turn red after the date 12/12/2019. Isn't it what you are trying to achieve?
All you need is to apply the conditional formatting similar to one in the file I uploaded and you only need to change the formula used for conditional formatting as per your date column.
In the sample file, I assumed that the dates are in column A and start from Row#2 and applied the conditional formatting based on the formula =AND(ISNUMBER(A2),EDATE(A2,3)<TODAY()).
So if in your original workbook, the dates are in column D and they start from Row#3, all you need is to select the range starting from D3 and apply a new rule for conditional formatting using the formula given below and set the format as per your choice.
If you still have difficulty in implementing the conditional formatting, upload a sample workbook so that we can help you to do that.
by Alan Skelly on June 01, 2020
by guojmaq on May 31, 2020
by Keggsy on May 11, 2020
Posted in Microsoft Ignite The Tour 2019 on February 14, 2020