Forum Discussion
frontdesksm
Aug 02, 2019Copper Contributor
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...
- Aug 06, 2019
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
frontdesksm
Aug 06, 2019Copper Contributor
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.
SergeiBaklan
Aug 06, 2019Diamond Contributor
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