Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create the formula "cumsum" in excel | Excel Worksheet Functions | |||
Create database in excel? | New Users to Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Training in Excel | Excel Discussion (Misc queries) | |||
create price list from excel sheet | Excel Discussion (Misc queries) |