How to create Macros to find range between H2:I2 & highlight Background color in same row where column heading value between H2:I2. And how will this code apply to whole worksheet range($L$2:$DC$1048576) Start Time End Time 19:15 19:30 19:45 20:00 20:15 20:30 20:45 21:00 20:00 21:00 21:00 1:30 4:30 7:30