Forum Discussion
Color coding
Hi everyone!!! i am a training coordinator so I have to keep track of a lot of dates. What i am wondering is if there is a way to code cells so that if it is almost a year from the date (about a mon...
thank you everyone!!
what I dont understand is why the rest of the dates are not turning yellow or red when I have dates in the past for practice.
I attached my sample file I am using to figure this out.
So far so good, you are welcome
I had it all wrong!! I changed the dates to reflect what I was actually saying and it worked perfectly!! Thank you for all your help!!!
No, they are not, but as of today, 12/15/19 should be red as it is past todays date and 1/29/2020 should be yellow as it is almost expired (that 335 day mark). Right?