How to use conditional formatting 30 day notice

clenk4304 Posts 1 Registration date Wednesday September 26, 2018 Status Member Last seen September 26, 2018 - Updated on Sep 26, 2018 at 11:32 AM
 Blocked Profile - Sep 26, 2018 at 01:29 PM
I have an excel document that I have set up some conditional formatting and use of icon sets. The only issue I am having, is programming the 30 day alert notice using conditional formatting. Here is my example of what I have in my excel document.

Cell (C3 holds the certification date) for example (Certified on 9/20/2017) is the certification date. Now I am using icon sets in cell C3 to either show me a green check mark if certification is valid and a red check mark if expired. My goal is to use another conditional format to highlight the C3 cell (yellow) when the certification date is approaching the 30 day expiration date. Does anyone know what i would use for code? Thanks

1 response