Multiple Highlight color (CF) + Macro setting help required.

Dear good people of Excel Forum,

I am here again to request help on trying to further perfect my Master_Template.
Please find attached my current excel, where I have also included [Text Boxes with wording in red outline] to explain what my goal is.

Event Itinerary MASTER_HELP.xlsm

Please see below,

▲Conditional Formatting Issues and Help Request.
(1) Highlight colors to go beyond the current day.
- To simply put it, the CF currently does not detect the next day.
In the excel, I have set my time to start at 07:00am [cell B6]. To test, I have written my "Event Start Time" at 01:00am [cell D2] and "Event End Time" at 03:00am [cell D3].
Current formula is
=AND($B6>=$D$2,$B6<=$D$3)
What do i need to add for this?

(2) Multiple highlight color CF in one same column, which is for multiple columns
- I have made an example on L10:L34.
C53:C64 are the 6 different colors.
D53:T64 is where I insert all the timings, and they should then be reflected into each of the columns above them in their respective colors.
Newbie here, is there a way to make this happen with only 5 formulas for the 5 colors? or will I have to do each color for each column individually?

▲Macro/VBA
(1) Automated Text Input of colored areas when clicking on "Button"
- After adding all the timings which then results in the colored areas on the columns, I would like to click on this "Time Calculator" button where I am looking to have it around U46.
Where the Macro will run and detect all the colored areas and insert the timings based on where they are placed on the time schedule. (Reflecting on Column B)
- Also to add a clear button to clear all time inputs.

*One additional item which I am not sure if this should be for CF or Macro/VBA.
There will be overlaps of color with my current excel template. For the areas where there are overlaps, I wish to replace or add with a stripe pattern.
The example is also on column L.

Sorry in advance if my explanations are not clear, let me know which areas are unclear and I will try to provide more information to the best I can.
Thank you!

Best,

Realized that the 1st issue regarding "CF Highlight for next day" can be solved by just continuing the time 25:00... 26:00... 27:00...
Suppose that would not be a problem for me if no other method is available.
But if anyone would be able to help me with the other task asked, that would be highly appreciated!
Thank you in advance!!

Or please let me know if there is something I left out which needs clarifications.

Hello again,

Been pondering and was able to solve the CF-(2) question.
=AND($B6>=D$63,$B6<=D$64)

--> Just had to tweak it a little bit. (swt)

If anyone can help me with the Macro that would be great cause I have zero knowledge on this.
Thank you!

Best,