Excel 2007 : Conditional Formatting

[sushil10s]

Hi,

Attached is the excel file and used are the formulas in Columns H, K & L. Please advise how to color (e.g, green) the entire row in the table if value in Column L is more than 1:00.

[NBVC]

Select the range and go to Home tab, then Conditional Formatting and select New Rule.

Select use a formula to determine which cells to format from top section and enter formula:

=$L8>TIME(1,0,0)

and click Format to choose from Pattern tab.