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
Select your date range ( assuming as starting in A2) and apply this conditional formatting formulas:
For green:
=A2<=EndOfFirstYear
For red:
=A2>EndOfFirstYear
For green:
=A2<=EndOfFirstYear
For red:
=A2>EndOfFirstYear
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
