Project Scheduler

[AndreaWilson]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Start Date[/TD]
[TD]Due Date[/TD]
[TD]3/28[/TD]
[TD]3/29[/TD]
[TD]3/30[/TD]
[TD]3/31[/TD]
[TD]4/1[/TD]
[TD]4/2[/TD]
[TD]4/3[/TD]
[TD]4/4[/TD]
[/TR]
[TR]
[TD]3/28[/TD]
[TD]4/2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/28[/TD]
[TD]4/1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/28[/TD]
[TD]4/4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I need help with a formula that would consider start date and due by date - then fill in the appropriate dates to the right with a color bar. I appreciate any help! Andrea

 

[markmzz]

Maybe this:

Select the range C2:J4 and use the formula below in the conditional formatting.

=(C$1>=$A2)*(C$1<=$B2)

Markmzz

 

[AndreaWilson]

Thank you!!! Works great!

Andrea

 

[markmzz]

Thank you!!! Works great!

Andrea

You are welcome.

I'm happy that your problem was solved and thanks for the feedback.

Markmzz