G
Guest
iI would like to create a training matrix that displays in a traffic light
i.e red = needs retraining. Green= trained. yellow = being trained. Each
cell would change to the required colour by typing R + date of training
completed would change this cell from green to red highlighting the need for
retraining. date of training completed = trained but when the date was moor
than 5 years the cell would change to red. BT =for being trained would turn
cell yellow
i.e red = needs retraining. Green= trained. yellow = being trained. Each
cell would change to the required colour by typing R + date of training
completed would change this cell from green to red highlighting the need for
retraining. date of training completed = trained but when the date was moor
than 5 years the cell would change to red. BT =for being trained would turn
cell yellow