June 21, 2020
I am trying to create conditional formatting to highlight date cells in a column that are in the future. I am currently trying this formula:
=AND($E15>TODAY(),$E15>=(TODAY()>30))
I have conditions using the standard drop downs for last month, this month and next month, but I want to highlight all dates after next month also. I have used >30 in the formula above to try and highlight everything longer than 30 days but it doesn't seem to work.
Would appreciate any guidance
Trusted Members
December 20, 2019
June 21, 2020
Thanks for your reply.
I have hopefully attached a sample file here :
As you will see, I have an orange highlight for dates next month but also trying to create the same for dates in the future after and beyond next month. You can see that dates for November are not being highlighted.
Hope I am explaining this clearly.
VIP
Trusted Members
December 7, 2016
June 21, 2020
Anders,
Thanks for that. I did try using the + but for some strange reason, it didn't work. It is working now though so thank you for that.
I have now noticed another issue now where I want to highlight past dates, the standard drop-down only has dates for last month which means those dates further back than a month don't get highlighted and remain blank.
Again I have tried tweaking the formula to get this result but seems to highlight even the blank cells. Clearly I am doing something wrong.
1 Guest(s)