MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Macro


Posted by Jim on April 21, 2001 12:30 PM

I need help with a macro. I need a way to shade a row of cells based upon input. ie.. if I have an input of 11 and another input at 22, I need a macro that will shade in cells from 11 to 22. Any ideas.
Thanks
Jim


Posted by Dave Hawley on April 21, 2001 1:32 PM


Hi jim

I could certainly write you a macro that would be triggered via the Sheet_change event. But have you looked at "Conditional Formatting" this can be found under Data on the main menu.

Dave

OzGrid Business Applications

Posted by jim on April 21, 2001 1:45 PM

I am writing a schedule program.... As I input the employees time ie 11 am until 5 pm, i need a way to shade that time in on another sheet. I'm looking at the conditional formatting right now.

Name In Out
GM 11 a 9 p
1st Asst mid 3a
Asst 2 p mid

10 11 12 1 2
---------------------------------


thanks