=SUM(A1:M1)*24=40

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"da haole boy" <da haole wrote in message
...
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.