I am using Excel 2007 on a Windows machine.
I am attempting to place one data bar and one data icon into a cell under the conditional formatting. The issue is that I don't really want to have data icons or data bars for cells that have dates in the future and I only want to have data icons for dates in the at least one month in the past.
This is what I have:
This is what I want:
I am using the
EOMONTH function to determine the last day of the month for the conditional formatting calculations. For the data bar the formula is
=EOMONTH(Now(), 4) and
=EOMONTH(Now(), -1). The data icons formulas are
=EOMONTH(Now(), -1) and
Is there a way in Excel 2007 to get rid of the data icons for all the dates in the future and lose the data bars when the date has past?