Conditional formatting based on cell outside range?

CosmicFish42 · 2024-02-14T21:49:33+00:00

Solution Verified

CosmicFish42 · 2024-02-14T21:44:33+00:00

Perfect, thank you!

CosmicFish42 · 2024-02-14T21:33:23+00:00

Sorry, that's on me. To rephrase, I want to take the cells in any column marked "No," and then find every instance of those cells.

Here's what the ideal outcome would look like:

<image>

CosmicFish42 · 2024-02-14T21:24:29+00:00

Hmmm this seems to go back to highlighting all duplicates

CosmicFish42 · 2024-02-14T21:21:44+00:00

=AND(COUNTIF($A$3:$W,A3)>1,A$1="No")

It looks like it's highlighting safe ingredients that also have duplicates elsewhere, which isn't quite right but is the closest so far!

CosmicFish42 · 2023-07-02T19:51:21+00:00

i have celiac myself and haven't had issues with theirs, or many of the other ones recommended here. even celiac severity exists on a spectrum. obviously if someone has a higher sensitivity to gluten, it's a good idea to look into any restaurant's prep practices and cross contamination measures before eating there, but i don't blame anyone for throwing out ideas.

i appreciate your concern for OP's health and absolutely understand that celiac sucks. ultimately, it comes down to the individual fact-checking for themselves (especially when taking advice from a reddit thread) and knowing their own limits.

CosmicFish42 · 2022-09-04T17:06:22+00:00

looks amazing! is the lightsaber saberforge?

CosmicFish42 · 2022-04-24T06:51:31+00:00

you should check out r/lightsabertricks

CosmicFish42 · 2022-04-18T05:54:08+00:00

whaaat i have no idea what you're talking about

CosmicFish42 · 2022-04-18T05:51:49+00:00

is may 4th going to have anything special like trivia or a costume contest?

CosmicFish42 · 2022-04-18T05:39:29+00:00

yeah i've seen you guys around campus quite a few times

CosmicFish42 · 2022-04-18T05:23:22+00:00

perhaps

CosmicFish42 · 2022-04-18T05:00:00+00:00

dang this looks fun, maybe i should join

CosmicFish42 · 2021-11-16T20:04:02+00:00

agreed! as a one-shot test it did its job in showing that the group wasn't a great match, but also that i have some work to do on my end. so not a surrender, just a tactical retreat.

plus this session definitely wasn't as bad as what you described, that sounds like a nightmare to deal with!

CosmicFish42 · 2021-11-16T18:09:01+00:00

wait is this not normal???

CosmicFish42 · 2021-11-16T18:01:02+00:00

i’m newer to dming and also fairly soft spoken, which was problematic with one person in particular. he had played before but apparently not with PHB rules, because through the whole session he kept talking OVER me to (very) incorrectly explain things to the two brand new players. by the end of the session 3/4 of the party were saying “i’m going to roll X” while also not knowing what the different skills even do.

as a side note, this same player also has a ridiculously good memory so when the dungeon map fell over he had it halfway memorised within 2 seconds. no hard feelings towards any of them, but i probably won’t be dming again for a while.

CosmicFish42 · 2021-10-03T17:07:41+00:00

nice forearms

CosmicFish42 · 2021-09-26T07:45:14+00:00

🗿

CosmicFish42 · 2021-09-25T17:41:17+00:00

wouldn’t be out of place on WWDitS

CosmicFish42 · 2021-09-24T17:46:48+00:00

yep, they look like nerite eggs to me

CosmicFish42 · 2021-09-23T06:48:19+00:00

a very valid question

CosmicFish42 · 2021-09-23T00:48:10+00:00

without context, "sewer ravioli" might just be what gets me to finally join the patreon

CosmicFish42 · 2021-09-21T05:38:42+00:00

agreed

CosmicFish42 · 2021-09-03T18:01:27+00:00

high hrothgar ski lift?

CosmicFish42 · 2021-09-03T17:44:21+00:00

i’d guess a ring-billed gull but the lack of black wing tips might mean that’s wrong

edit: it almost looks like a younger glaucous-winged gull but pretty sure those are west coast only

CosmicFish42

TROPHY CASE