Thank you in advance for any help you may be able to provide!

I would like to make the backgroud of a cell change color based on the
cells relaton to another cell.

For example;

The celles in column A are formated a Number/Custom/h.mm
The celles in column B are formated a Number/Custom/h.mm

I would like for the background of the cell in column B to be Blue if
the time in B is more then 30 minutes before the time in column A.

I would like for the background of the cell in column B to be white if
the time in B is less then 30 minutes before the time in column A and
less then 1 hour after then the time in column A.

I would like for the background of the cell in column B to be Red if
the time in B is more then 1 hour after the time in column A.

Thank you again.