Excel 2007 : Conditional formatting

[sushil10s]

hi

attached file...
wish to know a formula which can color
-dark red for total time >1:10
-light red for total time between 1:01 to 1:10
-Green for total time <=1:00

thanks

[arlu1201]

You do not need a formula, use the Conditional Formatting options available.