Hi there... I am in need of assistance in writing the formula for conditional formatting for dates that are about to expire? I am tracking business license expiration dates. I'd like to be reminded at 2 months, 1 month and 1 week, and expired
with colors defining each one. i.e. Red for expired, pink for 1 week, peach at 1 month and yellow at 2 months. I believe I can do this under managing rules, but I need the correct formulas.
Thank you!
