zeppelinmike
New Member
- Joined
- Jun 30, 2011
- Messages
- 9
Hi guys, can you help me?
I need to combine and IF and insert conditional formatting if possible.
I have a deadline month in A2 and a completion month in B2.
C2 is a Status field based on the progress of whether the deadline is < 6 months or > 6 months or >12 months( I currently manually enter in the Status progress whether its "Within Deadline"- (WD), "Beyond Deadline"-(BD) or "Completed".
I want to create an IF statement to do this automatically for me
<TABLE style="WIDTH: 227pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=302 x:str><COLGROUP><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3949" width=108><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; WIDTH: 81pt; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl22 height=20 width=108><TABLE style="WIDTH: 227pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=302 x:str><COLGROUP><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3949" width=108><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 81pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 height=20 width=108>Deadline Month</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 94pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 width=125>Completion Month</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 width=69 x:str="Status ">Status </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; HEIGHT: 14.25pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 height=19 align=right x:num="40725">Jul-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 align=right x:num="40848">Nov-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26>WD</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; HEIGHT: 14.25pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 height=19 align=right x:num="40575">Feb-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 align=right x:num="40787">Sep-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26>BD</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; HEIGHT: 42.75pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 height=57 align=right x:num="40603">Mar-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 align=right x:num="40603">Mar-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26>Completed</TD></TR></TBODY></TABLE></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; WIDTH: 94pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl22 width=125></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; WIDTH: 52pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl22 width=69 x:str="Status "></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 height=19 align=right x:num="40725"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 align=right x:num="40848"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 height=19 align=right x:num="40575"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 align=right x:num="40787"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8"></TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 42.75pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 height=57 align=right x:num="40603"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 align=right x:num="40603"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8"></TD></TR></TBODY></TABLE>
I would also like some Conditional formatting to colour this progress status automatically ( again I do this manually)
<TABLE style="WIDTH: 204pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=271 x:str><COLGROUP><COL style="WIDTH: 148pt; mso-width-source: userset; mso-width-alt: 7204" width=197><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 148pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 height=20 width=197>Progress</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 width=74></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff99cc; BORDER-TOP-COLOR: windowtext; HEIGHT: 14.25pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=19>Beyond Deadline < 6 Months</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff99cc; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>21</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc00; BORDER-TOP-COLOR: windowtext; HEIGHT: 14.25pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl27 height=19>Beyond Deadline > 6 Months</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc00; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl28 align=right x:num>0</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: red; BORDER-TOP-COLOR: windowtext; WIDTH: 148pt; HEIGHT: 42.75pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl31 height=57 width=197>Beyond Deadline > 1 Year</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: red; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl32 align=right x:num>0</TD></TR><TR style="HEIGHT: 28.5pt" height=38><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; BORDER-TOP-COLOR: windowtext; WIDTH: 148pt; HEIGHT: 28.5pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl33 height=38 width=197>Within Deadline</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26 align=right x:num>3</TD></TR><TR style="HEIGHT: 28.5pt" height=38><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #339966; BORDER-TOP-COLOR: windowtext; WIDTH: 148pt; HEIGHT: 28.5pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl34 height=38 width=197 x:str="Completed ">Completed </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #339966; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl35 align=right x:num>0</TD></TR></TBODY></TABLE>
Your help is greatly appreciated
Mike
<!-- / message -->
I need to combine and IF and insert conditional formatting if possible.
I have a deadline month in A2 and a completion month in B2.
C2 is a Status field based on the progress of whether the deadline is < 6 months or > 6 months or >12 months( I currently manually enter in the Status progress whether its "Within Deadline"- (WD), "Beyond Deadline"-(BD) or "Completed".
I want to create an IF statement to do this automatically for me
<TABLE style="WIDTH: 227pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=302 x:str><COLGROUP><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3949" width=108><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; WIDTH: 81pt; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl22 height=20 width=108><TABLE style="WIDTH: 227pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=302 x:str><COLGROUP><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3949" width=108><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 81pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 height=20 width=108>Deadline Month</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 94pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 width=125>Completion Month</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 width=69 x:str="Status ">Status </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; HEIGHT: 14.25pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 height=19 align=right x:num="40725">Jul-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 align=right x:num="40848">Nov-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26>WD</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; HEIGHT: 14.25pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 height=19 align=right x:num="40575">Feb-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 align=right x:num="40787">Sep-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26>BD</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; HEIGHT: 42.75pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 height=57 align=right x:num="40603">Mar-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 align=right x:num="40603">Mar-11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26>Completed</TD></TR></TBODY></TABLE></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; WIDTH: 94pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl22 width=125></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; WIDTH: 52pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl22 width=69 x:str="Status "></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 height=19 align=right x:num="40725"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 align=right x:num="40848"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 height=19 align=right x:num="40575"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 align=right x:num="40787"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8"></TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 42.75pt; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 height=57 align=right x:num="40603"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8" class=xl23 align=right x:num="40603"></TD><TD style="BORDER-BOTTOM-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #d4d0c8; BORDER-RIGHT-COLOR: #d4d0c8; BORDER-LEFT-COLOR: #d4d0c8"></TD></TR></TBODY></TABLE>
I would also like some Conditional formatting to colour this progress status automatically ( again I do this manually)
<TABLE style="WIDTH: 204pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=271 x:str><COLGROUP><COL style="WIDTH: 148pt; mso-width-source: userset; mso-width-alt: 7204" width=197><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 148pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl25 height=20 width=197>Progress</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-LEFT-COLOR: windowtext; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 width=74></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff99cc; BORDER-TOP-COLOR: windowtext; HEIGHT: 14.25pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl29 height=19>Beyond Deadline < 6 Months</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff99cc; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl30 align=right x:num>21</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc00; BORDER-TOP-COLOR: windowtext; HEIGHT: 14.25pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl27 height=19>Beyond Deadline > 6 Months</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc00; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl28 align=right x:num>0</TD></TR><TR style="HEIGHT: 42.75pt" height=57><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: red; BORDER-TOP-COLOR: windowtext; WIDTH: 148pt; HEIGHT: 42.75pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl31 height=57 width=197>Beyond Deadline > 1 Year</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: red; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl32 align=right x:num>0</TD></TR><TR style="HEIGHT: 28.5pt" height=38><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; BORDER-TOP-COLOR: windowtext; WIDTH: 148pt; HEIGHT: 28.5pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl33 height=38 width=197>Within Deadline</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl26 align=right x:num>3</TD></TR><TR style="HEIGHT: 28.5pt" height=38><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #339966; BORDER-TOP-COLOR: windowtext; WIDTH: 148pt; HEIGHT: 28.5pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl34 height=38 width=197 x:str="Completed ">Completed </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #339966; BORDER-TOP-COLOR: windowtext; BORDER-LEFT-COLOR: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl35 align=right x:num>0</TD></TR></TBODY></TABLE>
Your help is greatly appreciated
Mike
<!-- / message -->