| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell background color while searching through cells | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| how do I change cell background color only when cursor is over it | Excel Discussion (Misc queries) | |||
| Cell Background Color Change according to numerical value | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
