Hi people, i have set up a training spreadsheet with names and tasks, each
task under each name has a drop down list for level of training required,
level 1,2,3, level 1 = competent and turns green, 2 = more training required
and turns yellow, and so on, how can i then get the cell with persons name to
turn green when all tasks are level 1 and green. Thanks in anticipation of
your help.
--
Lewy