Aug 02 2019 12:48 PM
I would like to use two colors for coloring dates that are meetings. These dates are space out for the last three months. I want to color green for the first year and say red for the year beyond. I have tried several ways and not getting the same results.
My summary sheet has all formulas and the conditional formatting that I tried did not work the same way.
I have tried several tutorials and not getting the right answers.
P.S. I am using dates.
Aug 02 2019 12:55 PM
Aug 02 2019 01:07 PM
It did not work
Here is example"
A | B | C | D | E | F | H |
10/18/2018 | 6/7/2017 | 6/7/2017 | ||||
4/9/2019 | 11/27/2018 | 11/27/2018 | 11/29/2018 | 3/9/2018 | ||
10/23/2017 | 10/23/2017 | 10/24/2017 | 10/24/2017 | |||
8/30/2018 | 8/30/2018 | |||||
4/9/2019 | 2/1/2019 | 2/1/2019 | 2/1/2019 |
Aug 05 2019 12:05 PM
This did not work or I didn't understand the process. Here is another @Twifoo
A | B | C | D | E | F | ||
10/18/2018 | 6/7/2017 | 6/7/2017 | |||||
4/9/2019 | 11/27/2018 | 11/27/2018 | 11/29/2018 | 3/9/2018 | |||
10/23/2017 | 10/23/2017 | 10/24/2017 | 10/24/2017 | ||||
8/30/2018 | 8/30/2018 | ||||||
4/9/2019 | 2/1/2019 | 2/1/2019 | 2/1/2019 |
Aug 06 2019 01:20 AM
Please attach your sample file so that it would be easier to test the appropriate conditional formatting formula.
Aug 06 2019 06:24 AM
Attach is sample of what I am working with. I want to highlight less than year and red over a year old.
Thank You for your help.
Aug 06 2019 01:55 PM
SolutionPerhaps
=(A3>EDATE(TODAY(),-12))*ISNUMBER(A3)
for the green and
=(A3<=EDATE(TODAY(),-12))*(A3>1)
for the red, applied to =$A$3:$I$8
Aug 06 2019 01:55 PM
SolutionPerhaps
=(A3>EDATE(TODAY(),-12))*ISNUMBER(A3)
for the green and
=(A3<=EDATE(TODAY(),-12))*(A3>1)
for the red, applied to =$A$3:$I$8