32ihd f65zs h2ta3 hyrbz k6rhi 3zs7s sze56 ha3bz eih3k 998rb t4889 f2z2t deeh9 9s92y y676y f5tdf yz9sy 83fyn 43y78 t6nst 9ak66 Macro to highlight all rows that contain selected cell value |

Macro to highlight all rows that contain selected cell value

2022.01.20 20:29 Galdrian Macro to highlight all rows that contain selected cell value

Hi, so I know nothing about macros, but I have this spreadsheet at work I've been trying to make more user-friendly. I'd like to be able to highlight every row that contains the value in the selected cell. So for example, if we take this random table:

Faucet Discombobulate Yes
Raccoon Skydive Yes
Dumbbell Explode No
Faucet Skydive No
Raccoon Explode No
Ragamuffin Recycle Yes
Raccoon Discombobulate Yes

I want to make it so whenever I select a cell (say A2) and click a button, every row that includes the value in that cell (here, "Raccoon"), including the selected one, will be highlighted (so rows 2, 5 and 7). If I select another cell (like B1) and click the button again, I want the previously highlighted rows to go back to normal and the correct rows to be highlighted (so 1 and 7). I'd also like to put a "cancel" button just to remove all highlights, because there might be some empty cells in the chart so I won't be able to just click somewhere random. Might be worth mentionning some cells in the spreadsheet have some conditionnal formatting which would have to come back to normal when not being highlighted, and there are some merged cells which might ruin everything (but I might be able to unmerge them if that happens).
Is that at all doable (by a complete noob)? I'm not entirely clueless when it comes to code, but I've never worked with Excel macros and don't know that specific language. I messed around for a while and did terrible things. If any of you happened to have some script that can do something like that on hand that would be absolutely terrific.
Thank you!
submitted by Galdrian to excel [link] [comments]


2022.01.20 20:29 dataentrytard Enter to win over $2,000 worth of skincare products from Embrace Products Group Pty. 3 Winners! (01/31/2022) {US UK AU NZ}

Enter to win over $2,000 worth of skincare products from Embrace Products Group Pty. 3 Winners! (01/31/2022) {US UK AU NZ} submitted by dataentrytard to giveaways [link] [comments]


2022.01.20 20:29 kiddudder Take it back: Chiefs vs Bills hype video

Take it back: Chiefs vs Bills hype video submitted by kiddudder to KansasCityChiefs [link] [comments]


2022.01.20 20:29 TigerplaysMinecraft Interesting thing for a horse on stall rest

Hi my horse has injured himself and has to stay in his stable for 2 weeks I'd like to do fun and interesting games for him in his stable since he's going to be bored 😴 any ideas on what to do? Could be anything :)
submitted by TigerplaysMinecraft to Horses [link] [comments]


2022.01.20 20:29 Mr_Skecchi base stations

I was gifted an index, but its just the headset and controllers. base stations are out of stock. are base stations regularly available, or should i just give up and buy from htc? googling indicates giving up is the right choice but the search results are all for 1.0 or months old.
submitted by Mr_Skecchi to SteamVR [link] [comments]


2022.01.20 20:29 WrestlingBootyNBoobs Dani’s gorgeous cleavage and ass!

Dani’s gorgeous cleavage and ass! submitted by WrestlingBootyNBoobs to DanielleMoinet [link] [comments]


2022.01.20 20:29 Trouterspayce Very stoked on my new build

Very stoked on my new build submitted by Trouterspayce to xbiking [link] [comments]


2022.01.20 20:29 MattyO37 Happy to be offff πŸ™ŒπŸ»πŸ˜

Happy to be offff πŸ™ŒπŸ»πŸ˜ submitted by MattyO37 to FreeCompliments [link] [comments]


2022.01.20 20:29 pixelmallows [FOR HIRE] I'm accepting chibi commissions for 5 slots as my side gig starting at USD16 as I'm saving up for medications and consultation with the psychiatrist. Upvotes will help. Thank you!

[FOR HIRE] I'm accepting chibi commissions for 5 slots as my side gig starting at USD16 as I'm saving up for medications and consultation with the psychiatrist. Upvotes will help. Thank you! submitted by pixelmallows to artcommissions [link] [comments]


2022.01.20 20:29 offbett can someone fix my right eye to align with the left? never been able to take a real selfie (will tip)

can someone fix my right eye to align with the left? never been able to take a real selfie (will tip) submitted by offbett to PhotoshopRequest [link] [comments]


2022.01.20 20:29 sweetdreamsgirl Love my HEART!

Love my HEART! submitted by sweetdreamsgirl to LeCreuset [link] [comments]


2022.01.20 20:29 s0meth1ngGo0d Do wraps stay in the library when starting a new game? NFSH

Do wraps stay in the library when starting a new game? NFSH submitted by s0meth1ngGo0d to needforspeed [link] [comments]


2022.01.20 20:29 ZayJayPlays QC for Travis Scott Jordan 1?

QC for Travis Scott Jordan 1? submitted by ZayJayPlays to replicasneakers [link] [comments]


2022.01.20 20:29 obamachubaka Tempted to start caffeine again

Been off of caffeine for three months and I’m tempted to start caffeine again in moderation to help me focus on my med school application cause I can’t for the life of me focus otherwise. Trying to weigh the pros and cons rn and can’t help but side towards starting it again. Anybody have any input?
submitted by obamachubaka to decaf [link] [comments]


2022.01.20 20:29 ybaghops Cephalobot is the only robot villager I love and he’s my favorite octopus πŸ€–πŸ™

Cephalobot is the only robot villager I love and he’s my favorite octopus πŸ€–πŸ™ submitted by ybaghops to AnimalCrossing [link] [comments]


2022.01.20 20:29 HisashiMaeda EdoChara #005 Male πŸ˜„Discover the cool NFT art!

EdoChara #005 Male πŸ˜„Discover the cool NFT art! submitted by HisashiMaeda to opensea [link] [comments]


2022.01.20 20:29 Wildabobalore HGUC Xi Gundam

submitted by Wildabobalore to Gunpla [link] [comments]


2022.01.20 20:29 Jamerz49 Love this car

Love this car submitted by Jamerz49 to saab [link] [comments]


2022.01.20 20:29 Agreeable_Ad_7815 Australian blondie looking for someone to take care of her πŸ’πŸ’‹

Australian blondie looking for someone to take care of her πŸ’πŸ’‹ submitted by Agreeable_Ad_7815 to SugarDaddyMeet_Sites [link] [comments]


2022.01.20 20:29 liuserr [Cartier Santos] Dressed Down

[Cartier Santos] Dressed Down submitted by liuserr to Watches [link] [comments]


2022.01.20 20:29 Al42us Orlando drivers

Orlando drivers- did anyone get any quest for this week and/or weekend?
submitted by Al42us to uberdrivers [link] [comments]


2022.01.20 20:29 CivylSwivyl Now it's Melee time! Gimme your matchups for Princess Peach!

Now it's Melee time! Gimme your matchups for Princess Peach! submitted by CivylSwivyl to DeathBattleMatchups [link] [comments]


2022.01.20 20:29 TheMarijuanaConsumer Cherry Chem is the real deal

Cherry Chem is the real deal submitted by TheMarijuanaConsumer to ILTrees [link] [comments]


2022.01.20 20:29 Big_Stay5979 Kromatika officialised the collaboration with Chainlink! Chainlink Keepers is what enables the Kromatika protocol to have no gas fees, no swap fees, no front-running bots, and most importantly no price slippage.

Kromatika officialised the collaboration with Chainlink! Chainlink Keepers is what enables the Kromatika protocol to have no gas fees, no swap fees, no front-running bots, and most importantly no price slippage. submitted by Big_Stay5979 to CRYPTOPUMPCLUB [link] [comments]


2022.01.20 20:29 pawelk198604 How do nest one list into another in python 3 I need to put together two list (two-dimensional list) one contain string that contains name of subjects with the other that contains grades as float? It's codecademy excercise

submitted by pawelk198604 to Advice [link] [comments]


http://vlasertage.ru