Forum Discussion
Solved
Conditonal Formatting in Excel
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...
Perhaps
=(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
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 |
Please attach your sample file so that it would be easier to test the appropriate conditional formatting formula.
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.
Perhaps
=(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
