maximum amount of hours

bam12

Well-known Member
Joined
Dec 6, 2004
Messages
983
I need to set a maximum amount of hours a person may accumulate

so on i6 i have the formula sum(i4:16), but this I6 cant go over 720 hours and maybe have pop up come up when this reached

thanks in advance for any help
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
choose the cell
type the formula = sum(i4:i6)
(note: you can't choose i6, it will be circular reference)
goto format > conditional formatting > choose cell value greater than or equal to > type 720 as limit > choose format > you can change font colour or cell border or fill cell with bright colour or any format change of your choice. press OK

is this OK?
Ravi
 

Watch MrExcel Video

Forum statistics

Threads
1,114,381
Messages
5,547,613
Members
410,803
Latest member
lsweeney
Top