Conditional formatting

I am creating an electronic calibration document using conditional formatting. What is the formula to highlight a cell green when the date is greater than 30 days out, yellow when the date is within 30 days, and red if the date is today or past due?

I am creating an electronic calibration document using conditional formatting. What is the formula to highlight a cell green when the date is greater than 30 days out, yellow when the date is within 30 days, and red when the date is today or past due?

By: Harry

Leave a Reply

Your email address will not be published. Required fields are marked *