Can you make it so putting "Yes" in a cell column on Excel automatically makes it green and "No" automatically goes red? I have a bunch of stuff on a list I have to go through and create a column to denote whether each item on the list is a Yes or No.
Off Topic 2013
Collapse
Recommended Videos
Collapse
This topic is closed.
X
X
-
Re: Off Topic 2013
Can you make it so putting "Yes" in a cell column on Excel automatically makes it green and "No" automatically goes red? I have a bunch of stuff on a list I have to go through and create a column to denote whether each item on the list is a Yes or No. -
Re: Off Topic 2013
Conditional formatting.
Comment
-
Re: Off Topic 2013
I can see the website hits now.
It's actually not that bad when they are not filming. My mom went in there and said it was nothing like she expected.Lions, Tigers, Pistons, Michigan
OS Uni Snob Association Member
OS's most random Twitter account: @JustinTrenell
Originally posted by BruinsWhite doesn't clash with dark colors. Or most colors. That's the point of white.Originally posted by gordogg24pI think most of American history would disagree with you on that one.Comment
-
Comment
-
Re: Off Topic 2013
I'm pretty sure all of those pawn shop shows are almost completely faked.Member: OS Uni Snob Association | Twitter: @MyNameIsJesseG | #WT4M | #WatchTheWorldBurn
Originally posted by l3ulvlA lot of you guys seem pretty cool, but you have wieners.Comment
-
Re: Off Topic 2013
Select the column/row you want to format.
Under the Format tab select Conditional Formatting.
Put cell value equal to Yes and format it however you want. Add another condition and repeat for No.
Hope that helps.
Comment
-
Re: Off Topic 2013
My version of excel is super old so I'm not sure how much this will help with the differing menus.
Select the column/row you want to format.
Under the Format tab select Conditional Formatting.
Put cell value equal to Yes and format it however you want. Add another condition and repeat for No.
Hope that helps.Comment
-
-
Re: Off Topic 2013
I use Excel all damn day so I've now become an Excel snob. I hate it.
EDIT: Went back and read your initial post. Instead of selecting the entire workbook, you should just be able to highlight the column that the rule will apply to.Last edited by WazzuRC; 01-15-2013, 03:50 PM.Comment
-
Comment
-
Re: Off Topic 2013
Member: OS Uni Snob Association | Twitter: @MyNameIsJesseG | #WT4M | #WatchTheWorldBurn
Originally posted by l3ulvlA lot of you guys seem pretty cool, but you have wieners.Comment
-
Re: Off Topic 2013
Tracer inspired me to restart my own blogging efforts.
Read it if you like soccer, click the link and close out right away if you don't.
Not reading isn't an option. Butthole.Comment
-
-
Re: Off Topic 2013
Computers are rectangular... Did I help?MLB: Minnesota Twins
NFL: Philadelphia Eagles
NBA: Chicago Bulls, Minnesota Timberwolves
European Football: Manchester United, Brighton & Hove Albion
NCAA: UNI Panthers, Iowa Hawkeyes
Twitter: @mbless625Comment
-
Member: OS Uni Snob Association | Twitter: @MyNameIsJesseG | #WT4M | #WatchTheWorldBurn
Originally posted by l3ulvlA lot of you guys seem pretty cool, but you have wieners.Comment
Comment