HSX Forum

Movies

Huh, what? Did someone say my name?

Posted by: DTravel on Jun 14, 16:10 in response to RazorHawk's post Make a seperate "Dud" list that applies...

Depends a lot on what version of Excel you are using.  I did my (now non-functional) Starbonds spreadsheet on Excel 2003.  Where I work uses a later version but I've only had to do some quick and dirty conditional formatting there.

Summer Pick 5: life...uh...finds...uh...a way into the top 5...and Tomorrowland is yesterday's news tealfan Jun 14, 10:38

suggestion for chart... color movies that have been released but did not make top 5 or have dropped out of top 5 with light gray {nm} RazorHawk Jun 14, 10:50

I like it...if I could just figure out a way for Excel to automate it like the yellows & greens...i don't want to put them in by hand =P tealfan Jun 14, 11:05

Make a seperate "Dud" list that applies conditional formating? Extend your list beyond #5..Excel isnt my thing...DTravel chime in {nm} RazorHawk Jun 14, 11:36

Huh, what? Did someone say my name? DTravel Jun 14, 16:10

Same function for the yellows, just change the range to the new list. {nm} socby19 Jun 14, 13:22

I posted my follow-up question on the Life board, if you mind taking a look? {nm} tealfan Jun 14, 16:36

Not working for me... "Person removed the picture" or something like that... {nm} billy Jun 14, 11:26

correct link RazorHawk Jun 14, 11:37

oops!...sorry about that...I moved it to my HSX folder after posting {nm} tealfan Jun 14, 13:04

and here's the embedded image if your browser can see it... tealfan Jun 14, 13:11

#1!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Witness ME!!!!! MrZero Jun 14, 11:33

Right there with ya!!! {nm} capitolfi Jun 14, 13:05

I'm tied for 32nd - YAY! {nm} Chateau_du_Mal_Voisin Jun 14, 12:06

At this point, I hope JURA4 passes up AVNG2 so I have the same 2 pts everyone else gets :) {nm} JDolphin Jun 14, 15:21

So you two dig up dinosaurs? MattW Jun 14, 15:59





Post a Reply

To post to the forums you must first login!


I Play Rocky (IPROC) 150000 22.39 (+0.10)          Jackass: Best and Last (JCKA6) 150000 40.95 (+0.89)          Jackass: Best and Last (JCKA6) 44656 40.95 (+0.89)          Minions & Monsters (MNIO3) 150000 303.87 (-3.40)          Disclosure Day (SKIES) 150000 117.99 (+1.03)          Ebenezer: A Christmas Carol (EBNZR) 150000 88.44 (-0.34)          Polly Pocket (POLYP) 150000 18.21 (+0.01)          The Great Beyond aka Ghostwriter (ACRNS) 150000 117.29 (-0.66)          Fortitude (FRTUD) 150000 10.36 (+0.36)          Toy Story 5 - Opening Weekend (TOYS5.OW) 7000 148.07 (+1.60)          Wild Horse Nine (WILDH) 150000 11.95 (0.00)          The Amazing Digital Circus: The (AMZDC) 81054 24.69 (+0.11)          Minions & Monsters (MNIO3) 18422 303.87 (-3.40)          Wicker (WCKER) 150000 5.50 (+0.58)          Fortitude (FRTUD) 150000 10.36 (+0.36)          The Batman: Part II (TBAT2) 3000 264.89 (-0.17)          The Odyssey (ODYSE) 20000 301.53 (-1.21)          The Only Living Pickpocket in Ne (OLPNY) 150000 2.42 (+0.09)          Toy Story 5 - Opening Weekend (TOYS5.OW) 100 148.07 (+1.60)          Polly Pocket (POLYP) 150000 18.21 (+0.01)          Grandgear (GGEAR) 3000 59.65 (-0.27)          Fortitude (FRTUD) 150000 10.36 (+0.36)          Fortitude (FRTUD) 2000 10.36 (+0.36)          The Conjuring: First Communion (CNJU5) 3000 93.71 (+0.18)          The Batman: Part II (TBAT2) 3000 264.89 (-0.17)          Lukas Haas (LHAAS) 24999 52.38 (+0.17)          Fortitude (FRTUD) 150000 10.36 (+0.36)          Wicker (WCKER) 150000 5.50 (+0.58)          Wicker (WCKER) 150000 5.50 (+0.58)          The Batman: Part II (TBAT2) 3000 264.89 (-0.17)          Supergirl (SUPGR) 150000 143.60 (+4.87)          The Housemaid's Secret (HMAI2) 35000 94.51 (+0.16)          Elden Ring (ELDEN) 3000 56.91 (+0.20)          Lice (LICE) 3000 4.36 (+0.36)          Fortitude (FRTUD) 150000 10.36 (+0.36)          Lice (LICE) 3000 4.36 (+0.36)          Ono Ghost Market (ONOGM) 3000 94.42 (+0.16)          The Mummy 4 (MUMY5) 3000 100.13 (+0.33)          The Only Living Pickpocket in Ne (OLPNY) 149999 2.42 (+0.09)          The Only Living Pickpocket in Ne (OLPNY) 150000 2.42 (+0.09)          Fast Forever (FAF11) 3000 135.91 (+0.11)          Alexander Skarsgard (ASKAR) 25000 10.07 (-0.40)          The Comebacker (CMBAC) 150000 28.58 (+1.07)          Minions & Monsters (MNIO3) 4266 303.87 (-3.40)          The Beatles - A Four-Film Cinema (BEAT1) 3000 117.20 (0.00)          My Darling California (MDCAL) 1 21.87 (-0.46)          My Darling California (MDCAL) 1 21.87 (-0.46)          The Comebacker (CMBAC) 1 28.58 (+1.07)          Oh, the Places You'll Go (OTPYG) 3000 88.51 (+0.06)          The Comebacker (CMBAC) 1 28.58 (+1.07)