View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
goldhead
 
Posts: n/a
Default how do i create a training matrix in excel

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