M
medicdice
I am tracking training for my unit using an Excel sheet put out by the
military (must use).
The columns are each seperate training class and the rows are the individuals.
Each class has a Shelf life (must be completed with in a certain date. That
date<MOB=mobilization> is solid and does not change, all the other columns go
off that cell)
I have placed a conditional format on each column that changes the color
when they date corresponds to a designated shelf life (Green good red falls
out or expired).
I have a YES/NO column that states if the individual is deploying.
At the bottom of each column is a Number trained (COUNTA formula) that gives
a quick snap shot of how many has conducted the training.
for the information r3 refers to Row 3 due to the way the table was designed.
r6 NAME dploying class
r7 john no 1/oct/08 <grn>
r700 bill yes 1/oct/08 <grn>
r800 mary yes 1/aug/o8 <red>
r801 deploying=2 trained =3 total people=793
I would like to know:
1) how to get the number trained and filter out the NO's in deploying to let
me know of all those who are going are trained (some individuals in the class
are not going but have to participate for accountability).
2) How to get the number trained that correspond to the shelf life (green
for good, red for bad <color coresponds to date and the longetivity of the
shelf life>). Is there a way to count the Conditional Format colors?(if 100
people trained, say 40 are greeen and 60 are another color is there a way to
count just the Greens?)
military (must use).
The columns are each seperate training class and the rows are the individuals.
Each class has a Shelf life (must be completed with in a certain date. That
date<MOB=mobilization> is solid and does not change, all the other columns go
off that cell)
I have placed a conditional format on each column that changes the color
when they date corresponds to a designated shelf life (Green good red falls
out or expired).
I have a YES/NO column that states if the individual is deploying.
At the bottom of each column is a Number trained (COUNTA formula) that gives
a quick snap shot of how many has conducted the training.
for the information r3 refers to Row 3 due to the way the table was designed.
r6 NAME dploying class
r7 john no 1/oct/08 <grn>
r700 bill yes 1/oct/08 <grn>
r800 mary yes 1/aug/o8 <red>
r801 deploying=2 trained =3 total people=793
I would like to know:
1) how to get the number trained and filter out the NO's in deploying to let
me know of all those who are going are trained (some individuals in the class
are not going but have to participate for accountability).
2) How to get the number trained that correspond to the shelf life (green
for good, red for bad <color coresponds to date and the longetivity of the
shelf life>). Is there a way to count the Conditional Format colors?(if 100
people trained, say 40 are greeen and 60 are another color is there a way to
count just the Greens?)