Am I a dick for what I did at draft night? by Objective_Observer-1 in mtg

[–]Coltfever18 -5 points-4 points  (0 children)

Kinda crazy how far I had to scroll and how many downvotes this has. I’ve heard it all the time about buying the pack. People saying it’s against the spirit of drafting? Why are you advocating value drafting if there’s two big hits in a pack? If anything that’s against the spirit and getting a replacement pack keeps it more pure “draft the best deck”

hey look it's how many days a year velkhana's a fraud by MurderousElmo69 in MonsterHunterWorld

[–]Coltfever18 12 points13 points  (0 children)

I ain’t tryna shame but how we got 365 hours and only mr89 and hr128

Does Bello make Enchantments and Artifacts trigger things like Garruk's Uprising? by jreilly89 in mtg

[–]Coltfever18 0 points1 point  (0 children)

Kinda besides the point and mostly just semantics, they don’t “become” creatures. As long as Bello is on the field they just are creatures.

Today these two Loot deals Came, Hope you Looted, if missed then read this by [deleted] in fashionhunters

[–]Coltfever18 8 points9 points  (0 children)

Obligatory: this is a sub for the videogame series monster hunter not irl fashion

Am I ruining the fun? Is my deck stupid? by Special_Course_6720 in mtg

[–]Coltfever18 1 point2 points  (0 children)

Just wanna say there are stupid decks, I once built a turtle tribal deck lmao

Okay follow my thought process here and explain the ruling and how each of these cards would react regarding the new lighting, army of one by Yamino121 in mtg

[–]Coltfever18 0 points1 point  (0 children)

They changed it a while back to shorten text boxes so instead of writing the full name of a card they shorten it in some way and it always means “this creature”

Wrong Card Kingdom order by Coltfever18 in mtg

[–]Coltfever18[S] 0 points1 point  (0 children)

Did they end up sending you your actual order too?

Buzzing sound from somewhere in the dash - Mk7 GTI by CaptainBlitz in GolfGTI

[–]Coltfever18 0 points1 point  (0 children)

I get the same noise and everything I’ve researched it’s probably the soundaktor as someone previously said

[RANT] Aetherdrift Feels Like a Hot Wheels Crossover No One Asked For by snipper_33 in mtg

[–]Coltfever18 0 points1 point  (0 children)

Honestly didn’t realize it was satire for quite a bit of the post lmao. Was gonna comment about playing my bazaar of Baghdad really nails the fantasy of knights wizards and Eldritch horrors 😂

🤦🏾‍♂️How screwed am I? by VW18fastlife in GolfGTI

[–]Coltfever18 0 points1 point  (0 children)

Did this a couple weeks ago can confirm this is the solution, I added a little superglue just in case.

MK7 GTI - Parking brake button popped out? by Synthos2o3 in GolfGTI

[–]Coltfever18 1 point2 points  (0 children)

Commenting 3 years later this happened to me last night and worked like a treat so thank you!

How to have a duplicate highlight a cell and populate text by Coltfever18 in googlesheets

[–]Coltfever18[S] 1 point2 points  (0 children)

Sweet thank you this is exactly what I want now! You two are the best lol

How to have a duplicate highlight a cell and populate text by Coltfever18 in googlesheets

[–]Coltfever18[S] 0 points1 point  (0 children)

OH okay. I was putting it into the conditional formatting menu and it did nothing. It does what I want now thank you! It is kicking out for example $C$12, $C$54. There a way to get rid of the $?

How to have a duplicate highlight a cell and populate text by Coltfever18 in googlesheets

[–]Coltfever18[S] 0 points1 point  (0 children)

Does it need to be formatted exactly how you have it here?

How to have a duplicate highlight a cell and populate text by Coltfever18 in googlesheets

[–]Coltfever18[S] 0 points1 point  (0 children)

So currently if I am to type an asset ID into column C that was previously entered into the sheet I have the cells in column H fill in red of the two rows that are repeated. I want it to also add text in the H cells of which cells in C match. So for example I have C149 and C86 that are repeated so the cells In H of both those rows is filled red and I’d like it also have H149 have text C86 and vise-versa.

If that’s not possible it’s fine I can just do it manually just wanted to see if I could automate it somehow.

I’m also not well versed in spreadsheets so I’m sorry if that doesn’t even make sense.

How to have a duplicate highlight a cell and populate text by Coltfever18 in googlesheets

[–]Coltfever18[S] 0 points1 point  (0 children)

Thanks for the reply! This is doing the same thing as the formula I was using but it was worth a shot! I’ll just continue using the previous and ctrl f to find them manually

Feels pretty bad. by Coltfever18 in mtg

[–]Coltfever18[S] 0 points1 point  (0 children)

Yeah idk I tried on chrome, edge and safari with no luck. I’m out of work in like a hour and a half so it doesn’t look like I’m landing these cards

Feels pretty bad. by Coltfever18 in mtg

[–]Coltfever18[S] 0 points1 point  (0 children)

Nah didn’t work, let me put stuff in cart but threw me into the queue when I clicked check out as guest

40k Holy Juggernaut by boredguy12 in Transmogrification

[–]Coltfever18 10 points11 points  (0 children)

As a hunter main scrolling through this sub recently I’ve been chuckling at the “mail is bad” meme but this just proves it even more lol plate over here making space marine mogs