In need of formula for conditional formatting for expiration dates RRS feed

  • Question

  • 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!

    Tuesday, January 5, 2021 11:08 PM