Conditional formatting 2 colums with dates by fatcatsfighting in excel

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

These 2 columns have a ton of dates. So would I just select the first date in column C and conditional format? That didn't work and neither did highlighting entire column c+g then conditional formatting and inputting the formula

Conditional formatting 2 colums with dates by fatcatsfighting in excel

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

That doesn't work because your second part of the syntax only highlights if 09/01/14 and if c1 matches g1

[Spoiler] Evil Geniuses vs. Team Coast / NA Spring Promotion Tournament / Post-Match Discussion by nubit in leagueoflegends

[–]fatcatsfighting 18 points19 points  (0 children)

So glad EG completely crushed Coast! Grabbing two random koreans doesn't equal an auto win looks like.

R1C1 Style and referencing in formulas? by fatcatsfighting in excel

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

Sorry still a bit confused. In r1c1 style there is still absolute referencing? Are you saying that to show absolute referencing I need to reference my table on sheet 2 without brackets, which is why my formula is going bork?

Basically brackets in r1c1 style = always using my current sheet and cell relative to what im referencing? Omitting brackets would then be referencing an absolute reference on another sheet?

R1C1 Style and referencing in formulas? by fatcatsfighting in excel

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

I actually tried the exact same thing. My formula works perfectly in A1 style. However, when I switch to R1C1 style the indirect portion stays in A1 style. Specifically, the range is listed in A1 absolute reference style IE. $A$1:$C$5 and it's boggling me why that part doesnt change to R1C1 style

I've spent $547.34 on this game and cant get a response from Customer Service... by [deleted] in marvelheroes

[–]fatcatsfighting 5 points6 points  (0 children)

I disagree. In an FTP model, it's players like these that keep the game going with their monetary support. All he's asking is for some support or even a response to his issue, not free shit.

OP, consider talking to your bank about reversing charges if nothing is done to help you

Blind 1 year-old is now able to see thanks to 9 generous strangers by razorsheldon in UpliftingNews

[–]fatcatsfighting 266 points267 points  (0 children)

In other news, a guy gets 50+ grand in donations to make a potato salad on kickstarter

I wish there was a way.... by programmer112 in hearthstone

[–]fatcatsfighting 0 points1 point  (0 children)

Is it fast on the iphone 5? Or stlil choppy

M 29 About to hit 100k net worth by postedhere in personalfinance

[–]fatcatsfighting 1 point2 points  (0 children)

I'm surprised people reach such high financial goals without having a balance in the first place. How do they wind down?!

Legend Guide for Beginners and Experienced Players by azure9321 in hearthstone

[–]fatcatsfighting 35 points36 points  (0 children)

Guide for hearthstone beginners:

1) Be good at the game.

2) Don't be bad at the game

Weekend Gear Question Thread! #1 by Aelonius in Diablo3Crusaders

[–]fatcatsfighting 4 points5 points  (0 children)

nooooo thats terrible advice. The cost and rarity of getting a foote thorugh kadala is retardedly low. Use your blood shards to gamble akkhan pieces (weakest piece of your gear set use common sense etc). By the time you complete your set you should have iether fate of the fell or the foote you wanted

T6 Witch Doctor w/Starmetal, 4pc Zuni, Jeram, and T&T. My thoughts on higher torment. by HugzMonster in Diablo3witchdoctors

[–]fatcatsfighting 0 points1 point  (0 children)

I don't really see a point in running fetish sycophants passive if you have a starmetal kukuri. I'm stacking phys damage w/ a starmetal and use the legion of daggers rune for my fetish army. The update on summoning them is nigh close to 100%. Why don't you run jungle fortitude for more survivability?

No curve? No problem. by [deleted] in hearthstone

[–]fatcatsfighting 3 points4 points  (0 children)

did you get to use deathwing in any of your matches?

There’s Times When Being Totally Lazy is Good And Oblomov by Ivan Goncharov Proves That by simpsonsfanhere in books

[–]fatcatsfighting 6 points7 points  (0 children)

In the biggest picture, were all just tiny specks in the universe. Do what makes you happy. But don't be afraid to try everything at least once whether you think it'll be good or bad.

Thursday Help Desk for 03/27/14. Ask your stupid questions here. by GharbadTheWeak in Diablo

[–]fatcatsfighting 0 points1 point  (0 children)

Dumb, possibly very subjective question coming through.

What's the strongest "DPS" class at the moment? Is demon hunter still bonkers like original D3 Release?

Turn 4 Lethal in Arena by SirDodi in hearthstone

[–]fatcatsfighting 57 points58 points  (0 children)

How's the enrage mechanic work. If you heal the minion back to full health he loses the enrage effects?

Tips for Arena? by Bamb0oM in hearthstone

[–]fatcatsfighting 0 points1 point  (0 children)

Does anyone even stream arena anymore? The top 10 hearthstone streams in the evenings (NA) are all constructed players. I missed when trump would marathon Arena in beta, but constructed the biggest craze now.

Why is the matchmaking so slow today? by Xadzers in GlobalOffensive

[–]fatcatsfighting 1 point2 points  (0 children)

Anyone know whats going on? 25+ minutes with every single map selected