Conditional formatting formula

Mrlewis

New Member
Joined
Jan 23, 2019
Messages
15
Hi All,
I have been modifying a project spreadsheet and have a small issue. I'm using the conditional formatting with a formula that uses the percentage in another cell and the date range in other cells to colour milestones up to a certain date. It's seems to get to the milestone date only when I input 130 percent as opposed to 100 percent. Can anyone help with this please?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,418
Office Version
365
Platform
Windows
Re: Help needed with a formula in conditional formatting

Welcome to the Board!

I think we are going to need more information than that in order to be able to help you.
Please post your Conditional Formatting formulas, and the relevant data.

If is easier to show an image of the relevant data, there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
 

Mrlewis

New Member
Joined
Jan 23, 2019
Messages
15
Re: Help needed with a formula in conditional formatting

Thank you, I will post further details tomorrow as I can't do it from my phone currently.
 

Mrlewis

New Member
Joined
Jan 23, 2019
Messages
15
Re: Help needed with a formula in conditional formatting

Hi,

Details as follows:

=AND($J11>5%,$F11<=L$8,ROUND(NETWORKDAYS.INTL($F11,$G11)*$J11,2)+$F11+1>=L$8)

Cell values:
J11 is 100%
F11 is 01-Jan-19
G11 is 03-Mar-19

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th><th>Z</th><th>AA</th><th>AB</th><th>AC</th><th>AD</th><th>AE</th><th>AF</th><th>AG</th><th>AH</th><th>AI</th><th>AJ</th><th>AK</th><th>AL</th><th>AM</th><th>AN</th><th>AO</th><th>AP</th><th>AQ</th><th>AR</th><th>AS</th><th>AT</th><th>AU</th><th>AV</th><th>AW</th><th>AX</th><th>AY</th><th>AZ</th><th>BA</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #808080 ;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;color: #595959;background-color: #FFFFFF;;"></td><td style="text-align: right;color: #595959;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #99CCFF;;"></td><td style="color: #404040;background-color: #FFFFFF;;">Task in Progress</td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #404040;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #0070C0;;"></td><td style="color: #404040;background-color: #FFFFFF;;">Task Completed</td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;color: #595959;background-color: #FFFFFF;;"></td><td style="text-align: right;color: #595959;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: center;background-color: #FFFFFF;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;border-bottom: 1px solid black;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;border-bottom: 1px solid black;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;border-bottom: 1px solid black;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;border-bottom: 1px solid black;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;border-bottom: 1px solid black;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;border-bottom: 1px solid black;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;border-bottom: 1px solid black;font-style: italic;color: #FFFFFF;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #366092;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: right;color: #244062;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: right;color: #244062;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: right;text-decoration: underline;color: #244062;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: right;color: #244062;background-color: #BFBFBF;;"></td><td style="text-align: right;color: #244062;background-color: #BFBFBF;;"></td><td style="text-align: right;color: #244062;background-color: #BFBFBF;;"></td><td style="text-align: right;color: #244062;background-color: #BFBFBF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #808080 ;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">Jan-4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">Jan-11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">Jan-18</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">Jan-25</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">Feb-1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">Feb-8</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: center;color: #595959;background-color: #BFBFBF;;">PROJECT START DATE</td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #FFFFFF;;">31-Dec-18</td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: right;color: #595959;background-color: #BFBFBF;;">SCROLL TO WEEK #</td><td style="font-weight: bold;text-align: right;color: #595959;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #FFFFFF;;">1</td><td style="text-align: right;background-color: #BFBFBF;;"></td><td style="text-align: right;color: #366092;background-color: #808080 ;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="text-align: right;border-bottom: 1px solid black;color: #366092;background-color: #BFBFBF;;"></td><td style="text-align: right;border-bottom: 1px solid black;color: #366092;background-color: #BFBFBF;;"></td><td style="text-align: right;border-bottom: 1px solid black;color: #366092;background-color: #BFBFBF;;"></td><td style="text-align: right;border-bottom: 1px solid black;color: #366092;background-color: #BFBFBF;;"></td><td style="text-align: right;border-bottom: 1px solid black;color: #366092;background-color: #BFBFBF;;"></td><td style="text-align: right;border-bottom: 1px solid black;color: #366092;background-color: #BFBFBF;;"></td><td style="text-align: right;border-bottom: 1px solid black;color: #366092;background-color: #BFBFBF;;"></td><td style="text-align: right;color: #366092;background-color: #BFBFBF;;"></td><td style="text-align: right;color: #366092;background-color: #808080 ;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #FFFFFF;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">Machining</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">Priority</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">Action Owner</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">Start</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">Finish</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">Duration</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">Status</td><td style="font-weight: bold;text-align: center;border-left: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">%
Complete</td><td style="text-align: center;color: #FFFFFF;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #404040;background-color: #BFBFBF;;">31</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">1</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">2</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">3</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">4</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">5</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">6</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">7</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">8</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">9</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">10</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">11</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">12</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">13</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">14</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">15</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">16</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">17</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">18</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">19</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">20</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">21</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">22</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">23</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">24</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">25</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">26</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">27</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">28</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">29</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">30</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">31</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">1</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">2</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">3</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">4</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">5</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">6</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">7</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">8</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">9</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #BFBFBF;;">10</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #595959;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #595959;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #595959;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #595959;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #595959;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #595959;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;color: #595959;background-color: #BFBFBF;;"></td><td style="font-weight: bold;text-align: center;color: #595959;background-color: #BFBFBF;;"></td><td style="text-align: center;color: #FFFFFF;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;color: #404040;background-color: #D9D9D9;;">M</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">W</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">F</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">M</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">W</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">F</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">M</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">W</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">F</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">M</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">W</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">F</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">M</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">W</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">F</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">M</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">W</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">T</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">F</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #404040;background-color: #D9D9D9;;">S</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="font-weight: bold;color: #FFFFFF;background-color: #808080 ;;">Project Summary</td><td style="font-weight: bold;text-align: center;color: #FFFFFF;background-color: #808080 ;;"></td><td style="font-weight: bold;text-align: center;color: #FFFFFF;background-color: #808080 ;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">01-Jan-19</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">03-Mar-19</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #FFFFFF;background-color: #808080 ;;">44 day(s)</td><td style="font-weight: bold;text-align: center;color: #FFFFFF;background-color: #808080 ;;"></td><td style="font-weight: bold;text-align: center;color: #FFFFFF;background-color: #808080 ;;">93%</td><td style="text-align: center;color: #FFFFFF;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #808080 ;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="text-align: right;background-color: #808080 ;;"></td><td style="text-align: right;background-color: #FFFFFF;;"></td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #D9D9D9;;">Project 1</td><td style="text-align: right;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;color: #404040;background-color: #D9D9D9;;">01-Jan-19</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;color: #404040;background-color: #D9D9D9;;">03-Mar-19</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;">62 day(s)</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;color: #404040;background-color: #D9D9D9;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;background-color: #D9D9D9;;">100%</td><td style="text-align: center;background-color: #808080 ;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;background-color: #D9D9D9;;"></td></tr></tbody></table><p style="width:12em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Project Tracker</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L5</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">D6+(<font color="Green">I6-1</font>)*7</font>),5,4,3,2,1,0,6</font>)+D6+(<font color="Blue">I6-1</font>)*7</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">S5</th><td style="text-align:left">=L5+7</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Z5</th><td style="text-align:left">=S5+7</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AG5</th><td style="text-align:left">=Z5+7</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AN5</th><td style="text-align:left">=AG5+7</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AU5</th><td style="text-align:left">=AN5+7</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L8</th><td style="text-align:left">=M8-1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">M8</th><td style="text-align:left">=N8-1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">N8</th><td style="text-align:left">=O8-1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">O8</th><td style="text-align:left">=P8-1</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">P8</th><td style="text-align:left">=L5</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Q8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">P8,1,2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">R8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">Q8,1,3</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">S8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">R8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">T8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">S8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">U8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">T8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">V8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">U8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">W8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">V8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">X8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">W8,1,2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Y8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">X8,1,3</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Z8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">Y8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AA8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">Z8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AB8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AA8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AC8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AB8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AD8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AC8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AE8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AD8,1,2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AF8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AE8,1,3</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AG8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AF8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AH8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AG8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AI8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AH8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AJ8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AI8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AK8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AJ8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AL8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AK8,1,2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AM8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AL8,1,3</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AN8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AM8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AO8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AN8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AP8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AO8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AQ8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AP8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AR8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AQ8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AS8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AR8,1,2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AT8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AS8,1,3</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AU8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AT8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AV8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AU8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AW8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AV8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AX8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AW8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AY8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AX8,1</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AZ8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AY8,1,2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">BA8</th><td style="text-align:left">=WORKDAY.INTL(<font color="Blue">AZ8,1,3</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">L8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">M9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">M8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">N9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">N8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">O9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">O8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">P9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">P8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Q9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">Q8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">R9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">R8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">S9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">S8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">T9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">T8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">U9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">U8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">V9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">V8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">W9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">W8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">X9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">X8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Y9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">Y8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">Z9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">Z8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AA9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AA8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AB9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AB8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AC9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AC8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AD9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AD8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AE9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AE8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AF9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AF8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AG9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AG8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AH9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AH8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AI9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AI8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AJ9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AJ8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AK9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AK8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AL9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AL8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AM9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AM8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AN9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AN8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AO9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AO8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AP9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AP8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AQ9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AQ8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AR9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AR8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AS9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AS8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AT9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AT8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AU9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AU8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AV9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AV8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AW9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AW8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AX9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AX8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AY9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AY8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">AZ9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">AZ8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">BA9</th><td style="text-align:left">=CHOOSE(<font color="Blue">WEEKDAY(<font color="Red">BA8,1</font>),"S","M","T","W","T","F","S"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F10</th><td style="text-align:left">=IF(<font color="Blue">MIN(<font color="Red">F11:F31</font>)>0,MIN(<font color="Red">F11:F31</font>),""</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G10</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">G11:G31</font>)>0,MAX(<font color="Red">G11:G31</font>),""</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H10</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">F10="",G10=""</font>),"",NETWORKDAYS(<font color="Red">F10,G10</font>)& " day(s)"</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F11</th><td style="text-align:left">=IF(<font color="Blue">MIN(<font color="Red">F12:F16</font>)>0,MIN(<font color="Red">F12:F16</font>),""</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G11</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">G12:G15</font>)>0,MAX(<font color="Red">G12:G16</font>),""</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H11</th><td style="text-align:left">=DAYS(<font color="Blue">G11,F11</font>)+1&" day(s)"</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J10</th><td style="text-align:left">=AVERAGE(<font color="Blue">J12:J30</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J11</th><td style="text-align:left">=AVERAGE(<font color="Blue">J12:J15</font>)</td></tr></tbody></table></td></tr></table><br />


 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,418
Office Version
365
Platform
Windows
Re: Help needed with a formula in conditional formatting

In your formula, what exactly are you trying to do with this piece:
$F11<=L$8

Note that F11 is a date (
01-Jan-19) and L8 is a number (31). Dates in Excel are actually stored as number, specifically the number of days since 1/0/1900.
If you temporarily change the format of your date to "General", you will see that its numerical value is 43466. Since that number is greater than 31, that part of your formula will evaluate to FALSE.
As matter as fact, any date enter in F11 that is after the year 1901 will always cause that part to return false.

Are you trying to compare the DAY part of your date? If so, change that part of the formula to:
DAY($F11)<=L$8

And be sure to make that change anywhere else you are trying to make the same type of comparison.
 
Last edited:

Mrlewis

New Member
Joined
Jan 23, 2019
Messages
15
Hi,
I'm trying to highlight cells via the formula in conditional formatting to show progress on each day to the end date through a project depending on the percentage applied in J11.
It only seems to work (shows completion of the date) when 130% is input into this.
I have changed the formula but it highlights L11 which isn't always the start date of each task within the project.
 

Mrlewis

New Member
Joined
Jan 23, 2019
Messages
15
The formula is applied to cells L11 to BA11 if that helps
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,418
Office Version
365
Platform
Windows
It looks like J11 is actually a formula:
Code:
=[COLOR=#000000][FONT=Calibri]AVERAGE([/FONT][/COLOR][COLOR=Blue][FONT=Calibri]J12:J15[/FONT][/COLOR][COLOR=#000000][FONT=Calibri])[/FONT][/COLOR]
What values do you have in J12:J15?
I am trying to make a setup of your copy on my side to see if I can reproduce the behavior you are experiencing.

Also, which version of Excel are you using?

Also, please post the current function (since you made the changes), and explain what each part is supposed to be doing.
I do not want to assume the logic you are using based on the formula, in case there are errors in the formula.
 
Last edited:

Mrlewis

New Member
Joined
Jan 23, 2019
Messages
15
J12:J15 are all at 100%
They have a conditional formatting formula that highlights / colours a percentage of that cell depending on what percentage its at. I'll get back to you on the version of excel I'm using.
Thank you for your efforts.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,418
Office Version
365
Platform
Windows
OK, please also be sure to post the most current version of your formula, after the changes were made.
Also, it looks like it is an AND function with three different arguments.
The first argument is easy enough ($J11>5%), it is checking to see if J11 is greater than 5%.
Please explain exactly what the other two arguments in your formula are supposed to be doing.
 
Last edited:

Forum statistics

Threads
1,081,574
Messages
5,359,707
Members
400,545
Latest member
Damntheman30

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top