View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
da haole boy
 
Posts: n/a
Default 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.