I have a workbook that lists dates of training qualifications. The individual
cells use a conditional format for expiration, 30 and 60 days before
expiration. at the bottom of each column I would like to display the
percentage of current up to date training.
The conditinal formatting works and is as follows:

Cond. #1 or = =NOW()=31 No bacground color (training is
not expired)

Cond. #2 Between =NOW()=31 and =NOW()=30 Background
Yellow (30 days to expiration)

Cond. #3 < =NOW() Background Red (training expired)


What I need is at the bottom of the column of dates. I need a formula that
will return the percentage of cells that are current. Can it be done and if
so, how?