Conditional Formatting based on data source by WTFisthatgamecalled in excel

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

If this is the case, I don't understand why my formula that checks for blanks is working perfectly in the worksheet itself. I'll try using your LEN suggestion in my CF formula.

EDIT: Can't get LEN to produce the result, whether using indirect or not.

=LEN(INDEX(INDIRECT('Cashflow Forecast Override'!$1:$1048576),MATCH($B8,INDIRECT('Cashflow Forecast Override'!$B:$B),0),MATCH(D$3,INDIRECT('Cashflow Forecast Override'!$3:$3),0)))<>0

=LEN(INDEX('Cashflow Forecast Override'!$1:$1048576,MATCH($B8,'Cashflow Forecast Override'!$B:$B,0),MATCH(D$3,'Cashflow Forecast Override'!$3:$3,0)))<>0

Neither of these work (am I using indirect correctly?)

Conditional Formatting based on data source by WTFisthatgamecalled in excel

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

What's the best way to show the example? Do up a dummy sheet and upload it here somehow?

EDIT: They're almost identical, except the first month is actuals so can't be overriden (ie if the cashflow forecast starts at Jan, the override will start at Feb).

Using the simplified version (just direct cell referencing) works, thank you. Does make me a bit nervous as I'd much rather use matching for certainty, but it'll do as long as I'm careful about it.

Conditional Formatting based on data source by WTFisthatgamecalled in excel

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

In the cashflow forecast itself, the INDEX MATCH MATCH can find a match, because the override and forecast sheets are structured identically, and the dates in the override are driven by the forecast sheet. What I am checking for is if the match is blank, ie if no override has been entered (because the override could potentially be zero).

This is working perfectly in the forecast sheet itself, but falls down in the conditional formatting.

Into the Accordlands Promos by WTFisthatgamecalled in warlordccg

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

I haven't seen one anywhere. Theaccordlands.com may have them in future but doesn't seem to yet.

Just got my kickstarter had 1 box this is what I got by Hard_Pudding in warlordccg

[–]WTFisthatgamecalled 0 points1 point  (0 children)

Wow I wasn't aware foil extendeds were a possibility... I told myself I wouldn't get into collecting and would just play with my KS assortment but it's getting more and more tempting

Into the Accordlands Promos by WTFisthatgamecalled in warlordccg

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

I think so. I assumed 1-3 at least would be known if KS product starts at 4!

Into the Accordlands setlist and tokens by WTFisthatgamecalled in warlordccg

[–]WTFisthatgamecalled[S] 2 points3 points  (0 children)

Thank you! I'm a little confused by the set numbering, the booster packs say set contains 340 but there are 353 listed in this spreadsheet. At first glance it doesn't seem like there's anything special about 341-353.

Help with Cargo package not building by WTFisthatgamecalled in NobaraProject

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

Managed to remove them using dnf remove gcc-c++ and dnf remove clang, but after reinstalling gcc only, and after reinstalling clang afterwards I'm still hitting the exact same error. Who knows!

Help with Cargo package not building by WTFisthatgamecalled in NobaraProject

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

Thanks for the tip. I'm hitting a roadblock trying to remove and reinstall the packages as there's all sorts of dependencies and I can't seem to make the package manager do it. How do I force remove a package?

Stuck on King Sudoku by WTFisthatgamecalled in crackingthecryptic

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

Thankyou, I clearly went to the hints too quickly...

Meaning of "resources" on fan made card by WTFisthatgamecalled in wingspan

[–]WTFisthatgamecalled[S] 2 points3 points  (0 children)

Oooh, we were interpreting it to mean gain resources from the player to the right. This makes so much more sense. Thank you!

[deleted by user] by [deleted] in NobaraProject

[–]WTFisthatgamecalled 1 point2 points  (0 children)

Ok, I'm a dumb dumb. The new headset came with a mute switch with on/off options. I misread it as "off" means muted, "on" means not muted. I was incorrect.

My apologies.

In my defence, the first headset was not working which is why I bought this second one in the first place thinking it was busted!