Hello, this is my first post and I could really use some help with the problem. I'm setting up a roster for a boy scout troop. And using an upcoming date in relation to the date in the cell. I need to display one of three colors for that cell. Example: If Scout's med form (date displayed) expires in less than 30 days; fill said cell YELLOW, or if it's past due the cell is RED, if more than 30 days away, said cell is GREEN. All in relation to the current date when reading form.

I'm not sure if this is possible but if it is, I figured someone out there would know how to do it. Thank you for taking the time to read this.