Re: Hide or Highlight Row or Range based on changing cell value

Tech-Archive recommends: Speed Up your PC by fixing your registry

How is this selection accomplished. A name in a helper column? ??

--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
<batman07@xxxxxxxxx> wrote in message
news:1144781180.487596.279720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 *** 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



.

Quantcast