Originally Posted by Mujer

So I have a spread sheet that has the following formula
=IF(VALUE(G5)<H5,"Breached",VALUE(G5)-H5)

The Colum is formatted to be time as that is what it is calculating. This part is working fine.

What I am then trying to do is to apply the following conditional formatting
Cell Value = Breached - the cell is formatted Pink
Cell Value less than 09:00:00 - The cell is formatted red
Cell Value between 9:00:01 and 15:00:00 - The cell is formatted Orange
Cell Value between 15:00:01 and 30:00:00 - The cell is formatted Yellow
Cell Value greater than 30:00:01 - The cell is formatted Green

They are set up in this order. The Breach formatting works but the rest are not working.

Ie I have a few cells that are displaying 0:25:30 that are green and should be red.

What am I doing wrong?