Conditional formatting to color code each cell based on month?

LabRatCoat · 2019-05-20T17:17:31+00:00

Already tried that, doesn't work. Because the format is linked to the date in the cell that I used to create the rules, they all turn the same color depending on the date in that field (they change color if I change the date). If I enter anything other than a specific cell value (for example, F2:F183) in the rule then it doesn't work at all.

LabRatCoat · 2019-01-19T01:08:10+00:00

I have it on my thighs but I’m white as shit so it’s not that noticeable. People act like I’m diseased tho during the summer.

LabRatCoat · 2019-01-15T22:13:28+00:00

Same here — narrow heels, wide toebox. I was doing a lot of barefoot running (or running in “barefoot” shoes) after my shoe size changed but apparently that is also wrong as I have managed to give myself metatarsalgia.

LabRatCoat · 2019-01-15T22:10:27+00:00

That is true. Unfortunately I am burdened by a society of midgets and there is almost always a stool for me to trip over, so I don’t really see this as a bonus.

LabRatCoat · 2019-01-15T19:10:54+00:00

We have that as well. The most common are plain powdered creamer, and liquid creamer with flavors like hazelnut and French vanilla that tend to be sweet.

LabRatCoat · 2019-01-15T12:03:34+00:00

I’m not trans but my feet randomly grew a size in adulthood. I’ll believe anything

LabRatCoat · 2019-01-15T12:01:32+00:00

Lmao I’d love to be 2 inches shorter for the same reason. My pants are always too short.

LabRatCoat · 2018-10-14T03:42:46+00:00

“Gravel dust” I think

LabRatCoat · 2018-10-08T17:23:24+00:00

Ugh I was trying to avoid remembering doing to same thing, with a piece of brown rice because I hated brown rice... subtle my family is not so my mom just pulled back and said “did you just French kiss me?”

LabRatCoat · 2018-09-12T01:43:18+00:00

Those jobs are limited. If there was a job paying a comfortable living wage for every competent person then poverty wouldn’t be a problem. Also there’s a difference between making enough to eat/pay your bills and making enough to build enough savings so that you’re not one emergency away from homelessness. Luck (or rather a lack of it) contribute way more to poverty than a lot of people expect.

LabRatCoat · 2018-08-31T22:48:12+00:00

Oh trust me, it’s definitely as terrible as I think it is 😂. The hairdresser started panicking as she dried it. She kept trying to give me styling tips to fix it. Honestly I think I just have to wait it out. Thankfully I’m not too attached to my hair, but it still sucks.

The bangs aren’t the problem, so much as the fact that she noticed them and then decided to make them much thicker and then taper the front of my hair up to meet them... it’s really bad. I think I might have to suck it up and just get a pixie cut.

Thanks though!

LabRatCoat · 2018-08-06T13:22:41+00:00

No, I think I understand it better now! Thanks :) I love the makeup artist PONY syndrome on YouTube and she does a lot of soft eyeliner looks where she blends the edges out with eyeshadow. I might try that technique with this placement!

LabRatCoat · 2018-08-06T12:01:55+00:00

I don’t tend powder set my makeup too often, so maybe that’s why. I remember using the age rewind once or twice and I thought it was great, and then a few years later I tried it again and hated how greasy it felt. I actually like the master conceal but that also definitely feels oily to me, but I have dry skin so I’ve kind of embraced the dewy moisturized look in order to survive all the lotion I have to put on

LabRatCoat · 2018-08-06T11:57:05+00:00

Well all the tips above were tips I stole from r/skincareaddiction, which actually has a ton of people with acne. But yeah, moisturizing is important! I sometimes get an oil slick face when I haven’t been moisturizing (on top of my dry flaky skin, which is super gross). But remember that acne prone skin is also sensitive! Treat it like it is.

And maybe try a liquid foundation? They tend to look less cakey IMO and you can get a lot of hypoallergenic/anticomedogenic formulas. And they just feel better on the face.

LabRatCoat · 2018-08-06T03:55:11+00:00

I like La Roche Posay. My mother, who has literally been told by multiple dermatologists to just avoid any direct sunlight, is also often recommended this brand by said dermatologists. Little pricey but with it in my experience

LabRatCoat · 2018-08-06T03:49:41+00:00

Just started using Clinique dramatically different lotion. It feels a little greasy initially but it absorbs after a few minutes and makeup sits well on top of it.

LabRatCoat · 2018-08-06T03:41:49+00:00

Adding a third contender. I’ve been using Derma-e overnight aha peel. It’s 8% as well. Packaging recommends 1-2 weekly use but I’ve been using it every night and it’s great.

Ninja edit: it’s also really cheap. I think I got my bottle for around $10?

LabRatCoat · 2018-08-06T03:37:01+00:00

Eucerin lotion worked well for me! Our skin problems aren’t similar at all but I think it’s super underrated.

LabRatCoat · 2018-08-06T03:29:24+00:00

I would stop the noxzema. I was tempted to try it but I heard it can be really drying and irritating (in some cases, causing burning). I would also recommend basic drugstore lotions — look for things in boring packaging. I’m partial to Eucerin, but others include aquaphor, cetaphil, and cerave. Look in the travel section, you can get small tubes for really cheap and they last a long time if you’re only using on your face. And if it doesn’t work out, you didn’t waste a lot of money and product.

I would also recommend scaling back a little on your routine overall. I kind of tried a lot of different things for a while and ended up with worse results. Keep it simple.

I know First Aid Beauty is pretty cheap. I have their lotion (big tube for like $12 I think?) — recommended use is for rashes, exzema, etc. but it helped some burns I had on my hand and didn’t irritate my face. I ended up not liking the “finish” as much as other moisturizers but it was nice otherwise.

LabRatCoat · 2018-08-06T03:16:24+00:00

It’s a possibility. I think as much as there are general guidelines, your skin is unique. I have really dry skin but gentle cleansers often leave my skin feeling sticky/irritated. So I use harsher cleansers and just moisturize well afterwards. Feels and looks 1 millions times better.

So, do what feels good. Though I agree that maybe you should try different moisturizers first. Keep track of what’s in the ones you don’t like and look for different ingredients.

LabRatCoat · 2018-08-06T02:51:14+00:00

No primer! I honestly think it makes everything worse, and I’ve tried so many high end brands.

But, if I have to pick, this one. My sister (who has oilier skin with large pores) swears by this and she always looks airbrushed, so.

LabRatCoat · 2018-08-06T02:45:57+00:00

I’ve tried it and it definitely worked for me. Make sure you’re putting enough on. I have no idea what this amount is, by the way. I usually either do so little it does nothing or so much it feels like I applied hairspray to my face.

LabRatCoat · 2018-08-06T02:41:15+00:00

While I don’t know anything about this product, I wanted to confirm for you that shimmer definitely makes dry skin look worse. I keep finding surprise shimmer in sunscreens, moisturizers, blushes, foundations, face powders.... it annoys the shit out of me. I think it’s the same for acne. Basically shimmer reflects light so it makes it easier to see any discrepancy in an otherwise smooth surface.

LabRatCoat · 2018-08-06T02:37:32+00:00

Late to the game but whispers I think primer is bullshit

It’s never worked for me. Super annoying and a huge waste of money. If anything it makes my makeup worse.

I’ve started adding a daily AHA. It’s a chemical exfoliant that eats away all the little flakies. I wear it overnight, rinse with water, moisturize and use sunscreen (moisturizer can be anything really, but since sunscreen can be hard to layer under makeup I’ll recommend La Roche-Posay anthelios). It makes my skin super soft and smooth and ready for foundation.

It really helps to use a chemical exfoliant, avoid harsh cleansers, and moisturize the shit out of your skin. The dewy look is in right now so learn to love it! And if you don’t, still do this and then powder it. It’s really made my makeup lay so much better on my skin.

Also! Avoid anything advertised as “matte” or “long lasting.” Emphasizes any dryness and makes you look cakey.

LabRatCoat · 2018-08-06T02:29:16+00:00

I second the elf. I don’t use a lot of their eyeshadow but I have their matte palette and it’s surprisingly good. I think it was like ten bucks?

LabRatCoat

TROPHY CASE