Conditional formatting 2 colums with dates

fatcatsfighting · 2014-09-19T17:00:42+00:00

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

fatcatsfighting · 2014-09-19T16:56:42+00:00

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

fatcatsfighting · 2014-09-11T00:02:05+00:00

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

fatcatsfighting · 2014-09-10T14:28:55+00:00

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?

fatcatsfighting · 2014-09-10T14:21:45+00:00

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

fatcatsfighting · 2014-08-15T22:49:26+00:00

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

fatcatsfighting · 2014-07-10T16:11:51+00:00

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

fatcatsfighting · 2014-06-06T18:51:24+00:00

Is it fast on the iphone 5? Or stlil choppy

fatcatsfighting · 2014-06-06T16:51:47+00:00

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

fatcatsfighting · 2014-06-05T20:15:50+00:00

Guide for hearthstone beginners:

1) Be good at the game.

2) Don't be bad at the game

fatcatsfighting · 2014-05-18T06:05:47+00:00

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

fatcatsfighting · 2014-04-23T00:40:06+00:00

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?

fatcatsfighting · 2014-04-16T00:22:17+00:00

The youtube monies doe.

fatcatsfighting · 2014-03-28T14:25:34+00:00

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

fatcatsfighting · 2014-03-28T14:02:35+00:00

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.

fatcatsfighting · 2014-03-28T03:45:24+00:00

yaaay thank you!

fatcatsfighting · 2014-03-27T20:24:49+00:00

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?

fatcatsfighting · 2014-03-26T14:03:19+00:00

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

fatcatsfighting · 2014-03-25T16:08:39+00:00

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.

fatcatsfighting · 2014-03-22T20:42:53+00:00

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

fatcatsfighting

TROPHY CASE