In excel I have a cell which must be in d:hh:mm (day: hours: minutes) format which I want the cell to turn RED if the :mm goes over 30 minutes, but I want it to turn GREEN if the :mm are either equal to or less than 30 min. I'm having trouble getting the conditional formatting to work. Can anyone advise?