What conditional format can I use to highlight dates 28 mo. after another date?

Ben Christensen

I have a sheet that shows one column with my product ship dates, and a separate column with the warranty expiration date, which is 28 months after the ship date. All of the products have different ship dates, so the warranty expiration dates are different at every row.

I want to highlight the cell in the "warranty expiration" column when the warranty expires. ie: 28 months after the ship date. Is there a condition or formula that I can use to highlight these cells? I can add a hidden formula column if necessary.

Lisa LS Kennedy

Hi Ben,

Use conditional formatting and make a rule that looks at the Warranty expiration column. Use a condition like this or whatever window you are looking to flag

Lisa Kennedy

Senior Consultant | Smartsheet Development

Prime Consulting Group

Email: info@primeconsulting.com