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 |