Conditional format help/gannt plan

HI,

What do you mean?

regards

Is this what you want ?
gowflow
ganntV04.xlsm

cheers gowflow, yes exactly,superb, one thing though, if I copy and past start and end dates the x values dont appear

any ideas?

this is

yes for sure when you copy paste it does not activate change events !!!
what else you want a drink on the moon and hv the macro fires up the space shuttle to get back to earth /???

just kidding !
gowlfow

I do see that modifying the start and end dates is a wee bit buggy

pls clarify your quotes
give examples.
gowflow

Yes I reviewed it totally and check this one.
gowflow
ganntV05.xlsm

goflow, try and copy past the start/enddates from tasks 1 and 2 to lines 24/25 for example, the x values dont appear

my end goal is to conenct this to an oracle db where a query gets extracted into these columns and here I will have the same problem where the x doesnt appear

thoughts?

I like your challenges they push me more and more to refinement !!! although this seems to be very easy and conceivable when you post it first it is quite intricate as to programing it. What I like most about it is that it is very practical and easy to use and can have quite a few use to it !!!

Sometimes all we need is just ideas !!
great idea from you anyway.

Pls test it thoroughly
Regards
gowflow
ganntV06.xlsm

Hi again
I liked your idea so I went ahead and made it more realistic .. check out the below picture if you like it then I will b glad to share it with you by posting a new question when we get done with this one.
One Row 1 you have the Months
Row 2 is the first day of the week
I also highlighted every Quarter with a different color in weeks.

it is all flexible with today's date so if your next year it will automatically align to new data.
Regards

gowflow

will do, i am not sure though on the conditional formats, some calls have 2 formulas and some have 1, shouldnt this be consistant?

if i copy the start and end dates from row 25 to rows 27 to 31 other cells get highlighted not even in rows 27-31

thoughts?

in terms of next steps, things such as percentage complete would be handy, to track project progress

i logged a new question for th dynamic dates, its logged in the excel group

Pls put a link of the question here
gowflow

Wow, this all looks similar to a Leave Log I made almost 10 years ago when I was in the Navy.  I still kept a copy so here's what it looks like:I just now revised it to highlight the weekends and to give the highlighted days a 3D feel.  This just uses conditional formatting as well so there is no macro to update the days by adding or removing an "X".  However I do like the idea and I think I'll play with my version a bit.  Since mine is set by days and not by weeks I could only show 8 months at the most because at the time Excel had a limit of 255 columns.

One thing I think you need to do to make yours more dynamic is to base your date range on the dates you enter rather than from January to December.  Otherwise, how would you show the tasks that go from this year to the next year.  In my case, I took the minimum date of the "FROM" column and subtracted a week to get the first day my chart would display.

gowflow

 i am not sure though on the conditional formats, some calls have 2 formulas and some have 1, shouldnt this be consistant?

if i copy the start and end dates from row 25 to rows 27 to 31 other cells get highlighted not even in rows 27-31

thoughts?

TKs glad we finally nailed it.
I will keep this question monitored case you have new questions pls copy paste the address of the new question in here so I could help you in it case you need my assistance.
gowflow

sure, im thinking of adding 2 columns for actual start and end date to really track the project against the planned start and end dates, somehow be able to overlay the condition in a transparent colour so one can track it in the gantt,that would be cool,

ok no prb pls put a link in here and in the new quest say it related to this one
gowflow

Any news on your development ? is the file working fine any help needed ?
gowflow

seems ok but if we insert new rows the x values dont get added, it seems a rogue condition is doing this which I have now removed off the sheet

will add new spec in new call soon

no problem ! don't forget to put  link in here as soon as you post the question or else cannot attend (that is for sure if you need my help)
gowflow