Timeline Formula

M

MandieVOS

New Member
Joined
Apr 18, 2011
Messages
3
I am busy doing a timeline/project plan in excel. I need the formula so that the cells under the dates are filled with colour from the start to end date. Can anyone help? Please?

<TABLE style="WIDTH: 515pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=685><COLGROUP><COL style="WIDTH: 178pt; mso-width-source: userset; mso-width-alt: 8667" width=237><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" span=6 width=32><TBODY><TR style="HEIGHT: 31.5pt" height=42><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; WIDTH: 178pt; HEIGHT: 31.5pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl75 height=42 width=237>Task</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl75 width=78>Start Date</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl75 width=72>End Date</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl76 width=106>Responsible Person</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl77 width=32>18/04</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl77 width=32>19/04</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl77 width=32>20/04</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl77 width=32>21/04</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl77 width=32>22/04</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; WIDTH: 24pt; BORDER-TOP: #002060 2pt double; BORDER-RIGHT: #002060 2pt double" class=xl77 width=32>23/04</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl74 height=20>Study Competitor Websites</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl67> 18-Apr-11</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl67> 20-Apr-11</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl67> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; FONT-FAMILY: Arial; COLOR: white; FONT-SIZE: 8pt; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; BORDER-RIGHT: #ece9d8; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" class=xl78> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl68> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #002060 0.5pt solid" class=xl68> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl69 height=19>Investigate different CRM Software</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060 0.5pt solid; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl69 height=19>Decide on Web content</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl69 height=19>Decide on prices to put on website</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl69 height=19>Write brief website manual</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl69 height=19>Buy Camera</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl69 height=19>Take Photo's</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl69 height=19>Buy & Install CRM Software</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl69 height=19>Get Quotes for rework</TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl70> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD><TD style="BORDER-BOTTOM: #002060 0.5pt solid; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl66> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060 2pt double; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl71 height=20>Start Work</TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl72> </TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl72> </TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl72> </TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl73> </TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl73> </TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl73> </TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl73> </TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl73> </TD><TD style="BORDER-BOTTOM: #002060 2pt double; BORDER-LEFT: #002060; BACKGROUND-COLOR: transparent; BORDER-TOP: #002060; BORDER-RIGHT: #002060 0.5pt solid" class=xl73> </TD></TR></TBODY></TABLE>
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
MandieVOS said:
I am busy doing a timeline/project plan in excel. I need the formula so that the cells under the dates are filled with colour from the start to end date. Can anyone help? Please?

<TABLE style="WIDTH: 515pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=685 border=0><COLGROUP><COL style="WIDTH: 178pt; mso-width-source: userset; mso-width-alt: 8667" width=237><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" span=6 width=32><TBODY><TR style="HEIGHT: 31.5pt" height=42><TD class=xl75 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060 2pt double; WIDTH: 178pt; BORDER-BOTTOM: #002060 2pt double; HEIGHT: 31.5pt; BACKGROUND-COLOR: transparent" width=237 height=42>Task</TD><TD class=xl75 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 59pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=78>Start Date</TD><TD class=xl75 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 54pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=72>End Date</TD><TD class=xl76 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 80pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=106>Responsible Person</TD><TD class=xl77 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 24pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=32>18/04</TD><TD class=xl77 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 24pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=32>19/04</TD><TD class=xl77 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 24pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=32>20/04</TD><TD class=xl77 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 24pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=32>21/04</TD><TD class=xl77 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 24pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=32>22/04</TD><TD class=xl77 style="BORDER-RIGHT: #002060 2pt double; BORDER-TOP: #002060 2pt double; BORDER-LEFT: #002060; WIDTH: 24pt; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent" width=32>23/04</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Study Competitor Websites</TD><TD class=xl67 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent">18-Apr-11</TD><TD class=xl67 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent">20-Apr-11</TD><TD class=xl67 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 8pt; BORDER-LEFT: windowtext 0.5pt solid; COLOR: white; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none"></TD><TD class=xl68 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060 0.5pt solid; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl68 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl68 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl68 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl68 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>Investigate different CRM Software</TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060 0.5pt solid; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>Decide on Web content</TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>Decide on prices to put on website</TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>Write brief website manual</TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>Buy Camera</TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>Take Photo's</TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>Buy & Install CRM Software</TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>Get Quotes for rework</TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl70 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl71 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060 2pt double; BORDER-BOTTOM: #002060 2pt double; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Start Work</TD><TD class=xl72 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD><TD class=xl72 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD><TD class=xl72 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD><TD class=xl73 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD><TD class=xl73 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD><TD class=xl73 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD><TD class=xl73 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD><TD class=xl73 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD><TD class=xl73 style="BORDER-RIGHT: #002060 0.5pt solid; BORDER-TOP: #002060; BORDER-LEFT: #002060; BORDER-BOTTOM: #002060 2pt double; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
Click to expand...
What version of Excel are you using?
 
Upvote 0
MandieVOS said:
I am using Office 2007. I would be very delighted if you could assist.
Click to expand...
Ok, try this...

Column header dates in the range E1:J1

Start date in B2
End date in C2

Select the *entire* range E2:J11 starting from cell E2. Cell E2 will be the
active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell.
  • Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
  • Enter this formula in the box below:
  • =AND(COUNT($B2:$C2)=2,E$1>=$B2,E$1<=$C2)
  • Click the Format button
  • Select the Fill tab
  • Select a color
  • OK out
 
Upvote 0
T. Valko said:
Ok, try this...

Column header dates in the range E1:J1

Start date in B2
End date in C2

Select the *entire* range E2:J11 starting from cell E2. Cell E2 will be the
active cell. The active cell is the one cell in the selected range that is not shaded. The formula will be relative to the active cell.
  • Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
  • Enter this formula in the box below:
  • =AND(COUNT($B2:$C2)=2,E$1>=$B2,E$1<=$C2)
  • Click the Format button
  • Select the Fill tab
  • Select a color
  • OK out
Click to expand...
Thank you for the assistance, but unfortunately nothing happens in the selected cells. It made sense to set conditional formatting and I cannot understand why it does not work
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
VBA code clean up
Replies
9
Views
583
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
921
epactheactor
E

Forum statistics

Threads
1,224,599
Messages
6,179,831
Members
452,947
Latest member
Gerry_F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top