How to set up gradient for sleep graph in Google Sheets?

Question

Google Sheets

I want to set up a sleep chart gradient in google sheets.
Any ideas how to do it? (provided that the dream at 22:00:00 should be green, and at the conditional 23:59:59 more red)
(Field format - Time (Due to the duration, I had some kind of shit with formulas))

Answer 1

1) Select Cells
2) Format - Conditional Formatting
3) Select "Custom Formula"
4)=AND(INDIRECT("RC";0)<>"";INDIRECT("RC";0)>=(0/24) ;INDIRECT("RC";0)<(5/24))
5) Set format for this range (0-5 hours)
6) Repeat 2) - 5) for other ranges
Demo table