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