I use a workbook to track training dates for employees. The conditional
formatting and is as follows:

Cond#1 or= =NOW()=31 No background color (shows non-expired dates)

Cond.#2 Between =NOW() and =NOW()=30 Background is YELLOW (shows
30 days to expiration)

Cond.#3 < =NOW() Background is RED (shows expired training dates)


I need a formula at the bottom of the columns that will display the
percentage of non-expired dates (No background)