Date automatic

[lucid11]

HI,
I have an issue with an excel document.
I Have a start date column and an end date column and next a range of dates in the other columns.
My problem is how to color in black automatically these dates based on the start date and the end date.

For example:
Start date End date 1-oct 2-oct 3-oct
1/10/11 2/10/11 "blackBlack"
1/10/11 3/10/11 "blackblackblack"

The date format is dd/mm/yy!

Thanks!

 

[barry houdini]

Use conditional formatting.

Assuming start date in A2, end date in B2 and specific dates in C1 across then select the whole range starting with C2, e.g. C2:Z10 and use this formula in conditional formatting

=AND(C$1>=$A2,C$1<=$B2)

apply formatting as required > OK

 

[lucid11]

Very Thanks Barry, it works perfectly!

 

[lucid11]

Many thanks again Barry!
Now based on what I said before, imagine now that I have another column that represents the progress percentage.
How can I colored the specific dates with another color, of course, based on this percentage?