Hide or Highlight Row or Range based on changing cell value

[batman07]

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

 

[Don Guillett]

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

 

[batman07]

I have a combo box populated with the identical data that resides on
the sheet w/all of the schedules.

Sheets in the workbook are: Main & Posting. 'Main' contains the combo
box. When a schedule is selected here ('Main'), I have a Command
Button to call a macro to go to 'Posting', find the value that is in
'Main' (Main, cell E8) and highlight the range (row) (Posting) B:K.

If the highlighting is difficult, code to do simply a ctrl+f will
suffice. I tried to record a "find", and it would not work.

Thanks for the quick reply!!!

Jason