Hi,
I want to set some alerts in my sheet.
<TABLE style="WIDTH: 680pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=906><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 200pt; mso-width-source: userset; mso-width-alt: 9728" width=266><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" span=6 width=40><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=2 width=47><COL style="WIDTH: 15pt; mso-width-source: userset; mso-width-alt: 731" width=20><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 65pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=20 width=87>Department</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 200pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=266>Employee Name</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 46pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=61>Ver</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=68>1-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 53pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=70>2-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>3-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=40>4-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>5-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>6-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>7-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>8-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=47>9-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=47>10-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=20>##</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Lit</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.8 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.3 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.8 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.3 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Fin</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Ren</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>D</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>2.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>E</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>F</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Fin</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>G</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR></TBODY></TABLE>
So if the date matches today's date(or if I can define the days before the alert date) it should prompt me saying "This job is due in X days" or "This job is due today".
Can someone please help me on this?
Regards,
Chabuk
I want to set some alerts in my sheet.
<TABLE style="WIDTH: 680pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=906><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 200pt; mso-width-source: userset; mso-width-alt: 9728" width=266><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" span=6 width=40><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=2 width=47><COL style="WIDTH: 15pt; mso-width-source: userset; mso-width-alt: 731" width=20><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 65pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=20 width=87>Department</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 200pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=266>Employee Name</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 46pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=61>Ver</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=68>1-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 53pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=70>2-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>3-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=40>4-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>5-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>6-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>7-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=40>8-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=47>9-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=47>10-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=20>##</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Lit</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>B</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.8 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.3 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.8 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.3 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Fin</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>C</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Ren</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>D</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>2.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>E</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>F</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=20>Fin</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68>G</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 align=right>1.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right> - </TD></TR></TBODY></TABLE>
So if the date matches today's date(or if I can define the days before the alert date) it should prompt me saying "This job is due in X days" or "This job is due today".
Can someone please help me on this?
Regards,
Chabuk