featured_spectre

Would be amazing if you could Seb I am a bit daft when it comes to conditional formatting at the minute. I really ought to brush up on my excel skills!

Hmm... I must be being daft, I can't get it to pick the 7 dates in the If format....annoyingly!

Sorry if I am being dense, are you able to do an example? I can't get it going with the full colour set

Yes but is there any way to apply that to the cells in that chart as it is essentially a calendar which can scroll (don't ask me why it was like that, I got told to work with it)

Should add - progress will be manually input. not sure why, but hey how

Hi guys So, I am helping my stepdad design a project management spreadsheet for his company (don't ask, got roped into it). So I have created the basic template, but I am struggling to fill in the "gannt chart" part of it that he wants to use. I have attached the sheet. Basically, I need it to check in the cells in the "gannt chart" if it is within the dates listed, if yes, match the colour of the cell the date is (Red for initial submission, orange for decision date etc etc) Sample Gannt.xlsx Would be much appreciated. My googlefu is lacking, and when I suggested using a bar graph etc, it was flatly shot down.

thanks

Saw this yesterday.... Was pretty decent! And a literal follow on movie from T2 (removed T3, Salvation and Genesys from the timeline).

Netflix and Pils Occam Hazer Gotta pay the Pils Wish you were clear Duck Duck Booze Yeastus Christ Yellow Snow He Brew I will think of a few more @ICTDirect_Dave

Smooth Hoperator I'll have what the gentleman on the floor is having Pathological Lager My Wifes Bitter Ship faced Hoppyright Infringement Pour Decisions Rye2D2 These Beers were made for hoppin Sir Veza I'm so hoppy

Well...in that case... Citra butt down!

Yeaster Brew A pitcher worth a thousand words Pitcher Perfect Big Pitcher Grahams Tipsy Toes Draughted in 2019 A grin from beer to beer Grahams Boozed Ego

Hoptimus Prime Grahams Gloomy Goose 30 Hops or Null

Indeed

When I went there they said they ran the full workshop to MCSE etc.

I owe you a beer

They hold these things for members of the public, ranging from office certs to linkedin help etc. You'll need to give them a ring to find out the dates. Its the only microsoft store in Europe, so you can't mistake it for another

If you're able to get to the Microsoft store just outside Oxford Circus tube station, they run these frequently

Attached the file for you ...sample2.xlsx

i got the 100% calculation thing sorted FYI, I am just interested in the questions having scores if you know how I can do that

@bald_pig and @TomHD any ideas? sorry to bug you guys

I have this so far, based on your code...but doesn't work well =IF(COUNTIF(D15:D19,"=100%"),IF(AVERAGE(D15:D19)=100%,D8-0%),IF(COUNTIF(D15:D19,"<80%")=2,IF(AVERAGE(D15:D19)>=80%,D8-20.1%,AVERAGE(D15:D19)),IF(COUNTIF(D15:D19,"<80%")=3,IF(AVERAGE(D15:D19)>70%,D8-30%,AVERAGE(D15:D19)),IF(COUNTIF(D15:D19,"<80%")=4,IF(AVERAGE(D15:D19)>60%,D8-40%,AVERAGE(D15:D19)),IF(COUNTIF(D15:D19,"<80%")=5,IF(AVERAGE(D15:D19)>50%,D8-50%,AVERAGE(D15:D19)),IF(COUNTIF(D15:D19,"<80%")=6,IF(AVERAGE(D15:D19)>40%,D8-60%,AVERAGE(D15:D19))))))))

Well...lets say this.... There are 50 questions 5 are worth 3 points 45 are worth 1 point How can we get excel to assign that as a percentage value? and still use the scoring value if the 5 questions are failed?

Well lets add this in....if it is 100%, then reference another cell value? - - - Updated - - - And I would happily look at your cluster options, just need to think how I can work it in

It works for what I need, so I am happy