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
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