Percentage of Cells completed

  • Thread starter Thread starter womblew
  • Start date Start date
W

womblew

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?
 
Did not work. Regardless of the number of cells that were input as current,
the results were 50%. The formula needs to return the percentage of cells in
the specified range that meet the criteria of cond#1.
 
I'm sorry, I typed it wrong. This is the correct conditional formatting. The
"=" ater NOW is supposed to be a +. See below.

Cond. #1 > or = =NOW()+31 No background color (training is
I hope this helps.
 
Here is what the column looks like. The blanks are actually red or yellow.
The dates show as clear.

14-Jan-10
26-Jan-10
14-Jan-10



14-Jan-10

14-Jan-10

14-Jan-10
16-Jan-10

14-Jan-10

28-Jan-10

26-Jan-10
14-Jan-10
14-Jan-10

14-Jan-10


14-Jan-10

26-Jan-10
14-Jan-10


14-Jan-10

14-Jan-10

14-Jan-10
 
Back
Top