change cell background color when another cell's value => 40

D

da haole boy

I need an (Excel 2003 SP2) conditional formula that will change the formula's
cell color when the sum of a string of cell values (in hours & minutes)
becomes equal to or greater than 40:00, so as to visually indicate that
overtime is now & henseforth in effect.
 
B

Bob Phillips

=SUM(A1:M1)*24>=40

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
B

Bob Phillips

or even

=TEXT(SUM(A1:M1),"[h]")>"40"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top