• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Double Shaded Cells or Bars

M

MyCon

Member
Hi,

I wish to make a Gantt chart but the ones I've seen look good but not functional the way I would like or only partially usable for my needs

I'm seeking to have a double shade (maybe 3 shades or symbols later) cells or bars with "simple" conditional function that I can control through dates.

As you see through the attached example, the bars are manually shaded. Also, if possible, it would be nice to have milestone date & symbol but not as critical to have.

How can this be done through my attached file example?

Note - I don't know why I need to do this on an Excel forum but I had to change the file extension from ".xlsm" to ".doc" even though it's an Excel file to upload file.

** Change the extension to see "Excel" file **


Thank you
 

Attachments

Hi vletm & Others,

Thank you for replying back.

Your solution has the look I'm looking for but it appears to be a bunch of individual charts on top of each other. Also, it doesn't appear that these bars are controlled by the dates but dragged across to representative week duration - Similar to what I was doing manually.

Is there a way to get the same type of look but have the cells or rows be controlled through conditional functions & match up with dates both horizontally (August, 2015 through February, 2016) & vertically (The dates defined between Planned &/or Actual)

I plan to use this as a template later & will need to add a lot more rows.

Thank you
 
Hi Group,

Isn't there way to have a 2 or 3 shaded (conditional formatted) cells or rows?

I thought I've seen this done before.

Given the large list of WBS Tasks, charts doesn't work well, even if I split up & because I do a lot of filtering, then the charts look like crap.

Who can advise?

Thank you
 
@MyCon
1) There are NONE charts at all!
2) I can change it work by weeks too. Is Monday the whole week?
3) If You want to use 'CF' and You'll have a lot row row, You'll have soon a massive file!
4) Here, You can add as many rows as You want, without any changes of code. Now You mentioned filtering, that needs about two lines to add.
 
Hi,

I see something lie this working but not sure how to get it to work on my template.

=AND(E$1>=$B$5,E$1<=$C$5)

Cell references are not to my template but from another template in which I'm trying incorporate its functionality to my template.

I could you some assistance here.

Thanks
 
@MyCon
=AND(E$1>=$B$5,E$1<=$C$5)
all of those cells are empty, so the answer is TRUE.
and
my [Show]-button solution would work
if Sheet name is same that in Your sample and layout is same too...
 
Hi vletm,

I'm trying to get the shading to work like the attached example file I just found.

Go ahead & remove the green horizontal bars - Those were manually shaded.

If I can get my file to work similarly then I think I'll have what I need.

Thanks
 

Attachments

You must log in or register to reply here.
Back
Top