| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel how to be alerted when cells reach preset number?
We're setting up our payroll vacation accrual using Excel. How can I input
numbers each pay period and have excel add them up and alert me or signify when the numbers have reached the preset number of 960? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel how to be alerted when cells reach preset number?
You could use conditional formatting on the cell where you add up the
numbers, such that if Cell Value is Greater than or Equal to 960 then change the background or foreground colour. Hope this helps. Pete On Nov 20, 5:28 pm, EA wrote: We're setting up our payroll vacation accrual using Excel. How can I input numbers each pay period and have excel add them up and alert me or signify when the numbers have reached the preset number of 960? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count the number of cells it takes to reach a certain sum | Excel Worksheet Functions | |||
| Clear cells to a preset value | Excel Worksheet Functions | |||
| Clear cells to a preset value | Excel Worksheet Functions | |||
| I cannot reach the next cells in the xls worksheet | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
Linear Mode
