I have been dwelling on this for some time to no avail; any suggestions would
be gratefully received. Also, please forgive the sparse use of €˜technical
terms€¦

I have a large spreadsheet that, when finished, will be used as the main
data dump of training status for employees. Along the top (F:EO) is the list
of employee names, and down the side (4:67) is a list of all procedures
needed. The middle section is the corresponding date that a procedure was
trained to an employee along with the appropriate colour: Green +Date =
training valid; Yellow + Date = Training Incomplete/Superseded; or Red +
Blank [no date] = Training Required. All other non corresponding cells are
Grey.

Each Procedure has a €˜Revision Number, and when the number is updated (only
ever upwards, i.e. 1 then 2 then 3) all Training Date cells [non-blank??] on
that row should be changed to yellow.

What is the best way of automating this? If buttons, would you suggest a
command button for each procedure or a drop- down list??


Thanks in advance for any help,

Phin