macro highlighting the range according to value Please Help!!!

[Volga]

Guys! I need your help, i'm newbe in vba programming, but i need to make the task, thank in advance for your detailed help information

I have the exel book, the time schedule for staff at beuty salon. So I have the table as below:

Time Master
Sara Jessica Isabel
10.00-10.15
10.15-10.30
10.30-10.45
.....
20.00-20.15

I need to put to schedule the duration of the masters' work like 60, 90, 120 (minutes), I need to be highlighted down with definitive amount of rows in definitive range (B2:D30).
So as I understand it should be something with conditional formatting...but i can be wrong

I have some code, but it works not so ideal for my purpose, I don't know how to do it to specific range and not to active cells....

Please Login or Register  to view this content.

Maybe there are other ways to make this task done....

Moderators note: code tags added for you - this time

[FDibbins]

Hi and welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Having said that, if all you are doing is adding Conditional Formatting (yes, it sounds like that's what you need), then you may not need to use VBA.

Please explain/show in more detail exactly what you want?