HSX Forum

Movies

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

Posted by: tealfan on Jun 14, 11:05 in response to RazorHawk's post suggestion for chart... color movies that have been...

I need to refresh my memory on conditional formatting...

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!


Fuze (FUZE) 150000 17.89 (+1.15)          Fuze (FUZE) 150000 17.89 (+1.15)          Uptown Saturday Night (USATN) 150000 0.02 (+0.01)          Triplets (TRPLT) 150000 0.02 (+0.01)          Despicable Me 4 (DESM4) 1 258.35 (-0.25)          Bad Blood (BDBLD) 50000 0.12 (0.00)          The Shaggs (SHAGG) 150000 0.02 (+0.01)          Sweet Valley High (SVHI) 150000 0.03 (+0.02)          Twisting My Melon (TWSMM) 8 0.01 (-0.01)          Bad Behaviour (BBHAV) 150000 0.53 (-0.02)          The Absence of Eden (KHGRD) 200 0.14 (-0.02)          Sour Hearts (SOURH) 200 0.06 (-0.01)          Sour Hearts (SOURH) 200 0.06 (-0.01)          Back to Black (BTBLK) 150000 8.52 (-0.05)          Twisting My Melon (TWSMM) 1 0.01 (-0.01)          Spinal Tap II (STAP2) 100 25.42 (+0.59)          OVERLORD: The Sacred Kingdom (OLTSK) 150000 8.12 (-0.67)          Twisting My Melon (TWSMM) 4 0.01 (-0.01)          Fuze (FUZE) 150000 17.89 (+1.15)          The Legend of Zelda (ZELDA) 477 132.82 (-0.06)          Untitled Alejandro Gonzalez Inar (UAGIP) 10000 50.95 (+0.26)          Gabby's Dollhouse: The Movie (GABYD) 150000 24.34 (+1.64)          Gabby's Dollhouse: The Movie (GABYD) 20000 24.34 (+1.64)          Talk 2 Me aka Talk to Me 2 (TLKT2) 100 20.27 (+0.74)          OVERLORD: The Sacred Kingdom (OLTSK) 25000 8.12 (-0.67)          The Sequel Fund (SQUEL) 17033 20.04 (+0.03)          Touch (TOUC) 25 0.52 (0.00)          Sour Hearts (SOURH) 1 0.06 (-0.01)          Sour Hearts (SOURH) 100 0.06 (-0.01)          The Young Wife (TYWIF) 150000 0.11 (-0.03)          Gal Gadot (GGADO) 1 140.82 (+0.20)          Gal Gadot (GGADO) 10000 140.82 (+0.20)          Inside Out 2 - Opening Weekend (INOU2.OW) 100000 99.03 (-0.97)          Bad Behaviour (BBHAV) 150000 0.53 (-0.02)          The Six Billion Dollar Man (6MILL) 20000 20.19 (-0.06)          Brittany Snow (BSNOW) 10000 63.86 (-0.10)          Gabby's Dollhouse: The Movie (GABYD) 35000 24.34 (+1.64)          Touch (TOUC) 50 0.52 (0.00)          The Sequel Fund (SQUEL) 2967 20.04 (+0.03)          Gabby's Dollhouse: The Movie (GABYD) 35000 24.34 (+1.64)          Deadpool & Wolverine (DEAD3) 1 398.93 (-0.24)          The Sequel Fund (SQUEL) 20000 20.04 (+0.03)          Gabby's Dollhouse: The Movie (GABYD) 150000 24.34 (+1.64)          Gabby's Dollhouse: The Movie (GABYD) 35000 24.34 (+1.64)          Gabby's Dollhouse: The Movie (GABYD) 150000 24.34 (+1.64)          Young Woman and the Sea (YWATS) 150000 9.94 (+0.09)          Gabby's Dollhouse: The Movie (GABYD) 35000 24.34 (+1.64)          Inside Out 2 H$100 Put (INOU2.PU) 25000 2.37 (+0.37)          Inside Out 2 H$100 Call (INOU2.CA) 25000 2.02 (+0.02)          Young Woman and the Sea (YWATS) 150000 9.94 (+0.09)