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.