Highligh cell using date range (conditional formatting)

[lyka4715]

a pleasant day guys.

im having a problem of putting all shades using manual. do we have a formula like if I enter start date and end date, cells will be highlighted automatically. please see attached format.

http://i65.tinypic.com/24wztw2.jpg

 

[etaf]

Do you want different colours for each cell - in which case probably VBA
or if you want 1 colour then a conditional formatting rule

can you load a sample sheet - onto onedrive or dropbox
save me typing it all to give you an example code

BUT
you would use an AND()
test to see if the startdate id > = to the top line
and if the stop date is < = bottom line (2 cells)

 

[lyka4715]

Do you want different colours for each cell - in which case probably VBA
or if you want 1 colour then a conditional formatting rule

can you load a sample sheet - onto onedrive or dropbox
save me typing it all to give you an example code

BUT
you would use an AND()
test to see if the startdate id > = to the top line
and if the stop date is < = bottom line (2 cells)

Sir thank you for your reply. here the attached file.

im hoping to have it in VBA but if conditional formatting can do then it will be appreciated as well.

thanks in advance!

https://www.dropbox.com/s/3dtxzbq1tzs5lgr/test.xlsx?dl=0

 

[etaf]

i dont know VBA enough to reply to posts here
but here is a conditional formatting solution
just using a gantt chart excel formula

https://www.dropbox.com/s/yuc069k3tdyz0h9/test (etaf).xlsx?dl=0

 

[lyka4715]

i dont know VBA enough to reply to posts here
but here is a conditional formatting solution
just using a gantt chart excel formula

https://www.dropbox.com/s/yuc069k3tdyz0h9/test (etaf).xlsx?dl=0

thank you so much etaf!!!

this will save a ton of time for me.

 

[etaf]

you are welcome

 

[Ashwaq]

can you give me the solution for it? I'm having the same issue