Msg Box for any cells greater then 1st cell in the row

[markmeadows1]

ok if i have 5 rows

A1= 7
check the row b1:z1 and if any cell greater the cell A1 >7 return msg over limit
same for the rest of the rows
A2= 5
A3= 9
A4= 6
A5= 8

any help would be great

 

[meldoc]

Hello

Try.

=IF(MAX(B1:Z1)>A1,"Over limit","")

 

[markmeadows1]

Works Ok but I need a msg box to stop them going over the limits
Regards mark

 

[meldoc]

Hello again

Sorry I only just noticed this is your first post, welcome to MrExcel.

Try this in your sheet code module, right click on the sheet tab and choose View Code.
Tap F7 paste the code into the right hand code window, then ALT + F11 to return to Excel.

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Change(<SPAN style="color:#00007F">ByVal</SPAN> Target <SPAN style="color:#00007F">As</SPAN> Range)<br>  <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">Not</SPAN> Intersect(Target, Range("B1:Z5")) <SPAN style="color:#00007F">Is</SPAN> <SPAN style="color:#00007F">Nothing</SPAN> <SPAN style="color:#00007F">Then</SPAN><br>    <br>    <SPAN style="color:#00007F">If</SPAN> WorksheetFunction.Max(Range("B" & Target.Row & ":Z" & Target.Row)) _<br>      > Range("A" & Target.Row) <SPAN style="color:#00007F">Then</SPAN> MsgBox "Row " & Target.Row & " Over Limit"<br>    <br>  <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br><br><br></FONT>

 

[markmeadows1]

hi the codes works but as soon as i add formulas to the cells that add up points to the limite it stops. the cells from B to the end of the sheet have count if statements one for each team. the team can not go over the limits set in column A
its driving me mad

 

[energman58]

What are you trying to do - stop someone entering data somewhere (anywhere?) on the sheet that makes the sum of the values in any one of the rows exceed the limit in A1 to A5?

Is it ok to just give them a warning or do you want to force them to only enter data that meets the criteria?

 

[markmeadows1]

In Column A are the limits rows 2-9 for holiday in each department
In columns B to IS Rows 2-9 each cell as a count if statement that counts how many people in each depart have booked holidays i have cond formats but i need Msg to flag in the department tries to book over the limits so if cell k1 has counted 2 persons with the count if and you then try to book 1 more it will go over the limit but i need a msg warning saying so as the dont look at the con format

hope this helps


<TABLE style="WIDTH: 329pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=433 border=0 x:str><COLGROUP><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" width=26><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5449" width=149><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" width=40><COL style="WIDTH: 1pt; mso-width-source: userset; mso-width-alt: 36" width=1><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 950" span=6 width=26><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl217 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 20pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" align=right width=26 height=19 x:num>2</TD><TD class=xl218 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 188pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" width=250 colSpan=3 x:str="Enter: LH = Loading ">Enter: LH = Loading </TD><TD class=xl231 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; WIDTH: 1pt; COLOR: lime; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: teal; mso-ignore: style" width=1 x:num="0"></TD><TD class=xl255 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; BORDER-LEFT: black; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" width=26 x:num>1</TD><TD class=xl255 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; BORDER-LEFT: black; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" width=26 x:num="0"></TD><TD class=xl255 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; BORDER-LEFT: black; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" width=26 x:num="0"></TD><TD class=xl255 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; BORDER-LEFT: black; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" width=26 x:num>1</TD><TD class=xl255 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; BORDER-LEFT: black; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" width=26 x:num>1</TD><TD class=xl255 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; FONT-WEIGHT: 700; BORDER-LEFT: black; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" width=26 x:num="0"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl217 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" align=right height=19 x:num>2</TD><TD class=xl218 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white; mso-ignore: colspan" colSpan=2 x:str="Enter: GH = Goods In ">Enter: GH = GoodsIn </TD><TD class=xl219 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white"></TD><TD class=xl232 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: lime; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: teal; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BACKGROUND: #3366ff; BORDER-LEFT: black 1pt solid; COLOR: yellow; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" x:num>2</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>1</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BACKGROUND: #3366ff; BORDER-LEFT: black 1pt solid; COLOR: yellow; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" x:num>2</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BACKGROUND: #3366ff; BORDER-LEFT: black 1pt solid; COLOR: yellow; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" x:num>2</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BACKGROUND: #3366ff; BORDER-LEFT: black 1pt solid; COLOR: yellow; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" x:num>2</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl217 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" align=right height=19 x:num>6</TD><TD class=xl218 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" colSpan=3 x:str="Enter: FH = Freezer ">Enter: FH = Freezer </TD><TD class=xl232 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: lime; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: teal; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BACKGROUND: #3366ff; BORDER-LEFT: black 1pt solid; COLOR: yellow; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" x:num>6</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>5</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>2</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>4</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BACKGROUND: #3366ff; BORDER-LEFT: black 1pt solid; COLOR: yellow; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" x:num>6</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>4</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl217 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" align=right height=19 x:num>2</TD><TD class=xl218 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" colSpan=3>Enter: DH = Driver Recp</TD><TD class=xl232 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: lime; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: teal; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BACKGROUND: #3366ff; BORDER-LEFT: black 1pt solid; COLOR: yellow; BORDER-BOTTOM: black 1pt solid; mso-ignore: style; mso-pattern: auto none" x:num>2</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>1</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>1</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>1</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>1</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl217 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" align=right height=19 x:num>3</TD><TD class=xl218 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" colSpan=3 x:str="Enter: NH = Night Loading ">Enter: NH = Night Loading </TD><TD class=xl232 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: lime; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: teal; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>1</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>1</TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl217 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" align=right height=19 x:num>1</TD><TD class=xl218 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" colSpan=3>Enter: CH = Cleaners</TD><TD class=xl232 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: lime; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: teal; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl217 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" align=right height=19 x:num>1</TD><TD class=xl218 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" colSpan=3>Enter: BH = BUNS</TD><TD class=xl232 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: lime; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: teal; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD><TD class=xl254 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num="0"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl217 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white" align=right height=19 x:num>7</TD><TD class=xl218 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: white" colSpan=3>Enter: AH = Ambient</TD><TD class=xl233 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; BORDER-LEFT: windowtext 1pt solid; COLOR: lime; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: teal; mso-ignore: style" x:num="0"></TD><TD class=xl256 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>3</TD><TD class=xl256 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>4</TD><TD class=xl256 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>3</TD><TD class=xl256 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>3</TD><TD class=xl256 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>4</TD><TD class=xl256 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; FONT-WEIGHT: 700; BORDER-LEFT: black 1pt solid; COLOR: lime; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #969696; mso-ignore: style" x:num>3</TD></TR><TR style="HEIGHT: 21.75pt" height=29><TD class=xl257 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 81.75pt; BACKGROUND-COLOR: #333333" height=109 rowSpan=3>TAKEN</TD><TD class=xl261 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; WIDTH: 46pt; BORDER-BOTTOM: black 0.5pt dotted; BACKGROUND-COLOR: #333333" width=61 rowSpan=3>REF</TD><TD class=xl261 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; WIDTH: 112pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #333333" width=149 rowSpan=3 x:str="Name ">Name </TD><TD class=xl259 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: windowtext; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #333333" rowSpan=3>Department</TD><TD class=xl229 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: black" x:num="40635">Sat</TD><TD class=xl230 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40636">Sun</TD><TD class=xl230 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40637">Mon</TD><TD class=xl230 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40638">Tue</TD><TD class=xl230 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40639">Wed</TD><TD class=xl230 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40640">Thu</TD><TD class=xl230 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40641">Fri</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl221 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" height=17 x:num="40635"></TD><TD class=xl222 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40636">03</TD><TD class=xl222 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40637">04</TD><TD class=xl222 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40638">05</TD><TD class=xl222 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40639">06</TD><TD class=xl222 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40640">07</TD><TD class=xl222 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40641">08</TD></TR><TR style="HEIGHT: 47.25pt; mso-height-source: userset" height=63><TD class=xl245 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 47.25pt; BACKGROUND-COLOR: black" height=63 x:num="40635">Apr-04</TD><TD class=xl246 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40636">Apr-04</TD><TD class=xl246 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40637">Apr-04</TD><TD class=xl246 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40638">Apr-04</TD><TD class=xl246 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40639">Apr-04</TD><TD class=xl246 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40640">Apr-04</TD><TD class=xl246 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="40641">Apr-04</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num></TD><TD class=xl247 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: lime" x:num></TD><TD class=xl248 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: lime"></TD><TD class=xl248 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: lime">DH</TD><TD class=xl236 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: teal"></TD><TD class=xl237 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">O</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">DH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">DH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">DH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">DH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">DH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num></TD><TD class=xl240 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ff99cc" x:num></TD><TD class=xl241 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ff99cc"></TD><TD class=xl241 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ff99cc">GH</TD><TD class=xl236 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: teal"></TD><TD class=xl237 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">GH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">GH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">GH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">GH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">GH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num></TD><TD class=xl238 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffcc" x:num></TD><TD class=xl239 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffcc"></TD><TD class=xl239 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffcc">AH</TD><TD class=xl236 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: teal"></TD><TD class=xl237 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">AH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">AH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">O</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">AH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">AH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">AH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num></TD><TD class=xl242 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffff" x:num></TD><TD class=xl243 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffff"></TD><TD class=xl243 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffff">FH</TD><TD class=xl236 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: teal"></TD><TD class=xl237 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">O</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num></TD><TD class=xl242 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffff" x:num></TD><TD class=xl243 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffff"></TD><TD class=xl243 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ccffff">FH</TD><TD class=xl236 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: teal"></TD><TD class=xl237 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">FH</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num></TD><TD class=xl240 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ff99cc" x:num></TD><TD class=xl241 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ff99cc"></TD><TD class=xl241 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt dotted; BACKGROUND-COLOR: #ff99cc">GH</TD><TD class=xl236 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: teal"></TD><TD class=xl237 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">GH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">GH</TD><TD class=xl234 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; FONT-WEIGHT: 700; BACKGROUND: yellow; BORDER-LEFT: windowtext 0.5pt solid; COLOR: black; BORDER-BOTTOM: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none">GH</TD></TR></TBODY></TABLE>

 

[energman58]

Sorry - just to be clear. So what cells are they entering their holidays in - it looks like they start at F13 but where does that range finish. On the 4th April you have 2 booked off for DH but only one in the range you have shown. We need to know that so we can run the worksheet change procedure that checks if they have violated your constraint.

Also it is OK just to put up a message box that says "STOP - limit reached for that day" or something? We could make if the cell where you enter the data busts the limit the cell is cleared.

 

[markmeadows1]

f13 to f250 for the rest of the sheet https://picasaweb.google.com/markmeadows1/Excel?authkey=Gv1sRgCKWJiJmH3dfnrgE&feat=directlink

they countIf AH.LH.GH.NH and so on in rows 2-9 just need a warning that they must click ok if the count goes over the limit in cell A2-A9 So they have been warned

hope this helps

 

[meldoc]

OK

Try this, change ranges as required.

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Calculate()<br>  <SPAN style="color:#00007F">For</SPAN> i = 1 <SPAN style="color:#00007F">To</SPAN> 5<br>    <SPAN style="color:#00007F">If</SPAN> WorksheetFunction.Max(Range("B" & i & ":Z" & i)) _<br>      > Range("A" & i) <SPAN style="color:#00007F">Then</SPAN> MsgBox "Row " & i & " Over Limit"<br>  <SPAN style="color:#00007F">Next</SPAN> i<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>