I'm trying to create a conditional format that highlight cells in column e, when the date in column a, falls within a one year period.
I created a sumif function to add those amounts:
=SUMIFS(E14:E78,A14:A78,">"&D8,A14:A78,"<="&D8+365)
The start date is in cell D8.
In addition to summing the relevant cells though, I wanted to highlight them as well. However, I've tried inputing variations of the above formula into the worksheet and it's not really working out.
Does anybody have any suggestions?
Thank you.
Bookmarks