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

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.

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

=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.

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

or even

=TEXT(SUM(A1:M1),"[h]")"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.