Conditional formatting based on Time
This is a bit of a 2 part question, but it doesn't seem to work well on google sheets. It seems fairly straight forward.
I want to do a conditional format of one cell, based on the comparison of 2 different cells.
Example, a set of cells turn GREEN if the current time is greater than a certain number. To break it down further, if it's past 6:00am I want a set of blocks to turn green. If it turns 6:30 a different set of blocks turn green, and the ones from before go back to normal.