Needing help with Macro for highlighting specific rows.

[Frapp34]

Hello, I need help with a macro that would highlight specific rows, one of 3 colors based off the criteria in the E column.

We need to be at places at specific times, 06:00:00 - 09:00:00 09:00:00 - 12:00:00 12:00:00 - 15:00:00.

Was seeing if the whole row could be highlighted based off those times, 6-9 is blue, 9-12 is yellow and 12-3 is green.

Had to remove some sensitive info but if anyone could help that would be great. Thank you!!

 

[arthurbr]

Do you really need a VBA solution ? Simple Conditional Formatting would to the trick

 

[Frapp34]

Do you really need a VBA solution ? Simple Conditional Formatting would to the trick

Sorry first time on here and don't know that much about this stuff. I am using Excel 2019.

Heard people at work saying they used macros so i thought thats what i needed, but don't know about simple conditional formatting

 

[arthurbr]

You can find many tutorials around
One of them Conditional Formatting in Excel
In your case you will need to apply the CF to your entire table and use a formula like =$E3="09:00-12.00.00" to trigger the formatting for the first and create two other rules for the other colors
(and you definitely do not need VBA for this kind of task, unless other things should happen)