I am preparing a file that when an employee selects a schedule, ie.
sch75, the row it resides in needs to be marked off or hidden in
another sheet w/in the workbook. So ultimately when the last employee
selects a schedule, all 100 schedules (rows) will be hidden or
highlighted. I cannot get conditional formatting to work because each
employee will select a different schedule and the cell value will
change - causing the previous "marked" value to become "unmarked".

I am ok w/Excel, but not the programming piece. If someone would be
kind enough to assist me with the code, it will be greatly appreciated.


Thanks,
Jason