2021.09.17 22:37 WiseOldKid YES or NO Drop down list with color - changes 2 cells?
I am pretty new to Excel, so pardon me if this isn’t very clear.
I have added a yes/no drop down list option to 2 adjacent cells (A1 | B1)
I then made it so that if you select yes, it makes the cell green, and if you select no, it makes the cell red. To do this for cell A1, I simply selected the cell -> conditional formatting -> new rule -> use a formula tu determine which cells to format -> inserted =$A1=“Yes” -> format -> selected the color green -> “ok” twice. I repeated this process for the “No” option, and I also repeated it for the cell B1.
My problem is that selecting yes/no for cell A1 also changes cell B1’s color. I don’t know if this helps, but even if I invert the two cells position (B1 | A1) instead of (A1 | B1), selecting yes/no for cell A1 still changes cell B1’s color. This doesn’t work the other way around (B1 doesn’t influence A1).
How can I fix this?
Thanks in advance.
submitted by WiseOldKid to excel [link] [comments]
2021.09.17 22:37 ImSomeonePassingBy I saw a dragon today :)
|submitted by ImSomeonePassingBy to pics [link] [comments]|
2021.09.17 22:37 ShortAlgo #NUVA Waiting for Short signal. https://t.co/KS0dtOAnHs
|submitted by ShortAlgo to UltraAlgo [link] [comments]|
2021.09.17 22:37 MuchachoMunch Right stick opens split screen.
2021.09.17 22:37 Zest_82 A prequel spin-off series?
Would you like the next Macross show to be centered around the origin of the Zentraedi and the Supervision Army? Or if we go for the DYRL timeline, more about the Protoculture civilization?
submitted by Zest_82 to macross [link] [comments]
2021.09.17 22:37 MemeMakerMiranda My seasons tierlist. Yes i like pahkitew.
|submitted by MemeMakerMiranda to Totaldrama [link] [comments]|
2021.09.17 22:37 crispyjakal [Allison, ON][H]Paypal[W]Ryzen 3400g
2021.09.17 22:37 Cj56041 Missing in action new Bug
I went to talk with fralia and after her dialogue of her asking me to help her son the quest does not progress. i tried reloading and existing and re-entering the house. idk why the quest won’t progress. if anyone has any idea i would appreciate that.
submitted by Cj56041 to SkyrimHelp [link] [comments]
2021.09.17 22:37 Berm169 Anastasia Skyline
2021.09.17 22:37 SchIeitOfHand Top Minds: why did vaccine deaths suddenly increase when we became aware that anyone could anonymously report vaccine deaths to VAERS?
|submitted by SchIeitOfHand to TopMindsOfReddit [link] [comments]|
2021.09.17 22:37 m3ngnificient Friend sent a picture of a Baobab tree, and this was what came to mind
|submitted by m3ngnificient to gaming [link] [comments]|
2021.09.17 22:37 SlyAmaroqTarg It's a Jungle Out There
|submitted by SlyAmaroqTarg to ControlPhotography [link] [comments]|
2021.09.17 22:37 goldstrong [POSITIVE] for /u/jackstraw92 [buyer]
2021.09.17 22:37 SnooCats4105 Mold? Oryza Champagne Shimmer Eyeshadow
|submitted by SnooCats4105 to Ipsy [link] [comments]|
2021.09.17 22:37 drowning_frog need help with the writing section!
drop your best tip for the writing section (or anything you have at all to boost my scores), feel free to drop resources too!
after studying for two weeks, CB official tests, and grinding through khan academy, I got 1300 (first SAT, got 1190 on diagnostic in July :/) on aug28 which was min 70 points lower than my practice tests. I did sum stupid on math section got a 690 after getting 750+ on practice tests, then did the whole last passage wrong (analyzed SAS) after getting one wrong till 5th passage (hail my concentration) AND *DRUM ROLL* got ten wrong on my WRITING! TEN! and all were like "standard English convention" . was super annoying. (Eng - 610)
I have got some strategies prepared for math and reading for Oct 2 but writing ahgh I have no idea. targeting that 1400+ (I mean I can only hope)
thanks, guys, even 1300 would not have been possible without this community:)
submitted by drowning_frog to Sat [link] [comments]
2021.09.17 22:37 InjusticeAnne Is this Set Photo showing Andrew Garfield in No Way Home real or not?
|submitted by InjusticeAnne to marvelstudios [link] [comments]|
2021.09.17 22:37 gh_4u Local pronunciation
2021.09.17 22:37 LockedNLoaded9 First stamp!!! YHM Resonator K- 297 days from purchase
|submitted by LockedNLoaded9 to tacticalgear [link] [comments]|
2021.09.17 22:37 theteenyemperor I want affordable housing in metropolitan cities to look like the one in Vienna. If it's going to be high density, at least make it nice to live in and involve residents in the process.
|submitted by theteenyemperor to LabourUK [link] [comments]|
2021.09.17 22:37 Bobbited It grows super easily but get big and tips over. Maybe a vine?
|submitted by Bobbited to whatsthisplant [link] [comments]|
2021.09.17 22:37 reddit_feed_bot TheBlaze: Muslim student who pulled US flags from 9/11 memorial, tossed them into trash bags exercised freedom of speech: First Amendment law prof
|submitted by reddit_feed_bot to TheNewsFeed [link] [comments]|
2021.09.17 22:37 klars Language baskets with real objects for almost 13 month old
I'm reading Simone Davies "The Montessori Toddler" and she talks about using real objects initially for language baskets. I was thinking of setting us one with fruits and maybe one with vegetables, as my daughter is very interested in food. I don't think it is very practical to have out real fruits and veggies, as they wouldn't last long, so would you recommend using play food or how have you handled things like this? Should I just skip the perishable items and start with something else like kitchen utensils and then introduce the fruits and veggies as play food later? Thanks :)
submitted by klars to Montessori [link] [comments]
2021.09.17 22:37 Nnk2003 Coloured a manga page :)
|submitted by Nnk2003 to TokyoRevengers [link] [comments]|
2021.09.17 22:37 Conanzulu Just finished the Lost Chapel. I'm lost and stuck. I have questions (wotr)
I can't go north because of the demon army to the north. Mine isn't strong enough.
What else should I try and do?
How do you build items on the map like barracks?
Any suggestions to fight the stronger demon armies?
submitted by Conanzulu to Pathfinder_Kingmaker [link] [comments]
2021.09.17 22:37 catzsuck99 Do I have to grind a lot before fighting Seymour flux?
I’m on mount gazaget, and I got to the part where I have to fight Seymour flux. But he’s one shotting my party and completely wiping the floor with my team. What’s the trick to beat him?
submitted by catzsuck99 to FinalFantasy [link] [comments]