Conditional format help/gannt plan

folks

see sample attached, I have a gantt chart and I need the conditional format to change based on an amendment on the gantt tracking bar itself

refer to line 7 notes in the sample sheet attached

good luck
ganntV04.xlsm
rutgermonsAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
ok fine use this one instead. but believe Ver 07 in the next question is what you want. It has all the code that is in this one + the new formatting. This one will work fine as well.
gowflow
ganntV06A.xlsm
0
 
Rgonzo1971Commented:
HI,

What do you mean?

regards
0
 
gowflowCommented:
Is this what you want ?
gowflow
ganntV04.xlsm
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rutgermonsAuthor Commented:
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
0
 
gowflowCommented:
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
0
 
rutgermonsAuthor Commented:
I do see that modifying the start and end dates is a wee bit buggy
0
 
gowflowCommented:
pls clarify your quotes
give examples.
gowflow
0
 
gowflowCommented:
Yes I reviewed it totally and check this one.
gowflow
ganntV05.xlsm
0
 
rutgermonsAuthor Commented:
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?
0
 
gowflowCommented:
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
0
 
gowflowCommented:
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

Month Daygowflow
0
 
rutgermonsAuthor Commented:
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
0
 
rutgermonsAuthor Commented:
i logged a new question for th dynamic dates, its logged in the excel group
0
 
gowflowCommented:
Pls put a link of the question here
gowflow
0
 
IrogSintaCommented:
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:Leave LogI 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.
0
 
rutgermonsAuthor Commented:
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?
0
 
gowflowCommented:
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
0
 
rutgermonsAuthor Commented:
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,
0
 
gowflowCommented:
ok no prb pls put a link in here and in the new quest say it related to this one
gowflow
0
 
gowflowCommented:
Any news on your development ? is the file working fine any help needed ?
gowflow
0
 
rutgermonsAuthor Commented:
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
0
 
gowflowCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.