Hi all,
I am trying to do something which I thought would be easy but I am having lots of difficulties and really hoping someone can help please?
I have a start date and end date for a project.
I also have a list of week commencing dates at the top.
I would like the cells to be filled where the start date and end dates fall in those weeks. I hope that makes sense? It will allow me to plan better if I am able to see all weeks where these projects will be active.
I am trying to conditional format by entering in a formula but am sadly getting no where.
I have attached an example workbook, any ideas would be gratefully appreciated.
Many thanks in advance!
Last edited by Jessica.Bush; 02-07-2012 at 10:07 AM.
Unfortunately, it has not attached. Perhaps you could try again?Originally Posted by Jessica.Bush
Good luck.
Hi
No attachment...!
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Apologies, it should be attached now!
Thank you! :-)
Sorry! No again!!
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Ok
I saw it!!
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Thanks - I would appreciate any advice!
Select from C6:BC6 down as far as required, then use the following formula in the conditional formatting dialog
=OR(AND($A6>=C$1,$A6<=D$1),AND($B6>=C$1,$B6<=D$1),AND($A6<=C$1,$B6>=D$1))
You will need to add a date in BD1 (7-Jan-2013)for the last cell's format to work properly.
Good luck.
Hi
For an easy & simple solution. i use 2 helper(hidden) columns.(we can do without these, but in this way, is more simple)
Then the condition is simple..
=$A$6=E6
Take a look to the example.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
...And without helper columns....
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Fantastic, thank you for all of your options! :-)
You are welcome
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks