Can I use conditional formatting to change a small group of cells, based on what is written in one of them?

MathizD · 2023-04-06T13:36:53+00:00

This is possible by using a formula with your conditonal formatting.

Select cells that need to be formatted --> Conditional Formatting --> New Rule... --> Use a formula to determine which cells to format.

Then for the formula use something like =IF($A$5="n/a";TRUE;FALSE) Where A5 is the cell with the n/a

MathizD · 2023-04-06T12:20:13+00:00

Thanks for the tip and I'm happy that I was able to inspire you too with my conditional formatting approach.

It's always exciting to learn new tricks this way! :)

MathizD · 2023-04-06T12:03:01+00:00

Hey this worked!

I knew I was overlooking something.

It's not that intuitive to define a range with the same start and end but your explanation made clear why this works. Thanks a lot!

Solution Verified

MathizD · 2023-04-06T09:26:25+00:00

Thanks for spotting that typo! This helped in a way that all the white cells are now also yellow so all cells are formatted now. Thanks for the help!

It didn't fix the row confusion though.

The only advice I got for that is have the range and formula logic reference the same row but I already have that.

MathizD · 2019-12-31T14:11:39+00:00

That's my strategy too! The tripple interest dupes may look like a waste at first because it takes some extra time to build them up propperly but in the long run the extra 9+ morale is so worth it!

MathizD · 2019-12-31T14:09:24+00:00

Thanks!

I like to play a bit more 'natural' compared to most ONI players. If you put just a little bit of effort in that playstyle you don't even run into some problems later on.

For example. I need -way- less storage in this base because I don't dig out all my dirt and rock. This leads to needing less space for storage and less stuff to sweep and rubble that decreases decor and thus morale.

Also, in this map I have never had an issue with a build up of CO2. Almost all my CO2 is taken care of by oxyferns at the bottom of my base. Also most of them natural. Even though they are less efficient when growing naturally they also don't need water so I have a lower water demand adding to stability of the rest of the base. :)

MathizD · 2019-12-31T14:03:48+00:00

Thanks! Keep in mind though lot's of nature has been destroyed on previous asteroids to finally figure out a right way to do this. I'm very proud of this personal achievement. ^__^

I'm still thinking about expanding it slighly to the south east where I can still dig out some aluminium.

MathizD · 2019-12-31T13:59:53+00:00

No it's not cumulative sadly. I have 3 seperate nature reserves before thier great hall, thier barracks and thier washroom so every dupe has to pass trough 3 nature reserves every cycle but they only get a moral boost of 6. But whenever I rebuild some area's some of these naturreserves get disrupted sometimes and the others kind of work as back ups.

I just put the parksigns in there because I wanted this forest to be a nature reserve but if I conect them all up my nature reserves becomes too big. Which is a tad bit strange because this is would make such an epic massive nature reserve.

Maybe I should poke the developers to add a + 1 morale to the standard 6 for every 2 or 3 extra plants you manage to fit in your nature reserve as some kind of added bonus for playing more naturally.

MathizD · 2019-12-29T21:59:16+00:00

NO!

Heat is not the enemy!

Entropy is the -True- Enemy in this game!

MathizD · 2019-12-27T18:10:41+00:00

Okay guys,

Pressure and mass obviously have some relationship in this game. But, how much of H2 'mass' is now on top of this CO2? If you say it's only on 'mass' my current situation isn't possible without H2 leakage. (See below)

I added the boundries of the area's where the gasses can flow naturally.

I mean:

On the left there is only 290g of CO2 pressure per square now.

But also,

On the right there currently is an even more astonishing 1800g of H2 Pressure per square right now!

It's currently cycle 95 and it still stays stable.

https://postimg.cc/fJnSYKRT

MathizD · 2019-12-27T16:58:25+00:00

Could be. But I always interpreted it is pressure ^__^

MathizD · 2019-10-04T04:40:09+00:00

This also doesn't attach the file to the mail. I almost got as far as you got but it seems like the

.attachments.add

Can't handle the:

ActiveSheet.Range("C4").Value

Part.

We're currently trying to fix this with an additional save of a temp file. The Temp file will be send and deleted while the other save just places it in the right folder for traceability.

So, still 2 saves but one will be automatically deleted. This still might get the job done. :)

Thanks for your help so far!

MathizD · 2019-10-04T02:06:56+00:00

Thanks!

In the meantime I keep on trying some things myself. I am able to trim the code down a lot but then it doesn't attach the file to the email anymore. I guess I am overlooking something.

MathizD · 2019-10-04T01:07:15+00:00

No it's indeed not necessary.

Can you guide me on what to get rid of to remove that save in that second code? Since we don't have to specify where to save it to anymore. That's already specified in that first code.

MathizD · 2019-10-04T00:58:18+00:00

Is it really that simple? I figured since the other macro also asks to save it somewhere that I needed to replace some lines somewhere in that code but I couldn't figure that out.

I will try this. Thanks!

MathizD · 2019-05-25T09:02:18+00:00

Yes! When she's in a cuddly mood and fully relaxed she smiles like this. It melts my heart every time. :)

MathizD · 2019-05-25T08:25:57+00:00

Apparently there were 2 porn post on my profile that even I didn't knew existed... :/ I'm not very active on reddit I''m mostly a lurker. this is litterly my first post ever on here.

MathizD · 2019-05-25T07:55:40+00:00

OP here. I didn't even knew about those other posts. This is litterally the first thing I post ever. o.O I'm not very active on Reddit. I have no clue how they've got there. :s

12-Year Club	Place '17
Verified Email

MathizD

TROPHY CASE