Off Topic 2013

Collapse

Recommended Videos

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • TheMatrix31
    RF
    • Jul 2002
    • 52901

    #1441
    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.

    Comment

    • Fresh Tendrils
      Strike Hard and Fade Away
      • Jul 2002
      • 36131

      #1442
      Re: Off Topic 2013

      Originally posted by TheMatrix31
      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.
      Yes.

      Conditional formatting.



      Comment

      • justblaze09
        Swaggy Poole
        • Mar 2007
        • 3523

        #1443
        Re: Off Topic 2013

        Originally posted by Nathan_OS
        We're beautiful like diamonds in the sky, shine bright like a diamond.

        Favorite song..

        Sent by The Chicago Bulls Organization
        Someone take this man's man card away from him, NOW!

        Originally posted by TracerBullet
        I was actually thinking about doing it on my hockey watching exploits this year. We'll see though. I'll check out wordpress as well.
        2 Black Lions Fans tackle hockey.

        I can see the website hits now.

        Originally posted by 13
        Yeah, she's a pain in the ***, and the son's hairline is borderline criminal.

        However, the only reason I watched for like a solid 4 hours last night, was the ****ery that is the customer base in Detroit. Just, speechless lol
        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 Bruins
        White doesn't clash with dark colors. Or most colors. That's the point of white.
        Originally posted by gordogg24p
        I think most of American history would disagree with you on that one.

        Comment

        • TheMatrix31
          RF
          • Jul 2002
          • 52901

          #1444
          Re: Off Topic 2013

          Originally posted by Fresh Tendrils
          Yes.

          Conditional formatting.
          Hmm. I selected the entire column and set the parameters but nothing is happening. Argh.

          Comment

          • Bellsprout
            Hard Times.
            • Oct 2009
            • 25652

            #1445
            Re: Off Topic 2013

            Originally posted by 13
            Yeah, she's a pain in the ***, and the son's hairline is borderline criminal.

            However, the only reason I watched for like a solid 4 hours last night, was the ****ery that is the customer base in Detroit. Just, speechless lol
            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 l3ulvl
            A lot of you guys seem pretty cool, but you have wieners.

            Comment

            • Fresh Tendrils
              Strike Hard and Fade Away
              • Jul 2002
              • 36131

              #1446
              Re: Off Topic 2013

              Originally posted by TheMatrix31
              Hmm. I selected the entire column and set the parameters but nothing is happening. Argh.
              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

              • TheMatrix31
                RF
                • Jul 2002
                • 52901

                #1447
                Re: Off Topic 2013

                Originally posted by Fresh Tendrils
                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.
                The one I'm using here is Excel 2003. Tried that and it didn't work. Not sure why it's not working. Bah. Damn Excel. I'll mess around with it, I guess.

                Comment

                • Fresh Tendrils
                  Strike Hard and Fade Away
                  • Jul 2002
                  • 36131

                  #1448
                  Re: Off Topic 2013

                  Are you putting quotations around the word?



                  Comment

                  • WazzuRC
                    Go Cougs!
                    • Dec 2002
                    • 5617

                    #1449
                    Re: Off Topic 2013

                    Originally posted by TheMatrix31
                    The one I'm using here is Excel 2003. Tried that and it didn't work. Not sure why it's not working. Bah. Damn Excel. I'll mess around with it, I guess.
                    FT is on the right track. Go to conditional formatting --> new rule. Select the new formatting rule as "format only cells that contain" and change "cell value" to "specific text" containing yes. Format with your color font and hit okay. Repeat for the "no" value. Then go into "manage rules" and make sure that it applies to the entire workbook (click the top left arrow between column A and row 1 of the workbook to select all cells), not just A1. It should apply to something like =$1:$1000000. That should work.

                    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

                    • ImTellinTim
                      YNWA
                      • Sep 2006
                      • 33028

                      #1450
                      Re: Off Topic 2013

                      Originally posted by Fresh Tendrils
                      Are you putting quotations around the word?
                      Cell value equal to, then in the command box type ="Yes" and ="No" for the two different rules.

                      That's the quick and easy solution.

                      Comment

                      • Bellsprout
                        Hard Times.
                        • Oct 2009
                        • 25652

                        #1451
                        Re: Off Topic 2013

                        Member: OS Uni Snob Association | Twitter: @MyNameIsJesseG | #WT4M | #WatchTheWorldBurn
                        Originally posted by l3ulvl
                        A lot of you guys seem pretty cool, but you have wieners.

                        Comment

                        • Mo
                          SSN
                          • May 2003
                          • 11425

                          #1452
                          Re: Off Topic 2013

                          Originally posted by Dayman
                          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.
                          I didnt read it, but I stole from you.
                          Don't you EVER read my blog? It's gotten a lot better.

                          Comment

                          • Fresh Tendrils
                            Strike Hard and Fade Away
                            • Jul 2002
                            • 36131

                            #1453
                            Re: Off Topic 2013

                            Originally posted by Dayman



                            Comment

                            • mb625
                              DJ2K
                              • Jan 2012
                              • 5016

                              #1454
                              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: @mbless625

                              Comment

                              • Bellsprout
                                Hard Times.
                                • Oct 2009
                                • 25652

                                #1455
                                Re: Off Topic 2013

                                Originally posted by Mo
                                I didnt read it, but I stole from you.
                                Your header picture is way, way, way better than mine.

                                Natalie Zea...
                                Member: OS Uni Snob Association | Twitter: @MyNameIsJesseG | #WT4M | #WatchTheWorldBurn
                                Originally posted by l3ulvl
                                A lot of you guys seem pretty cool, but you have wieners.

                                Comment

                                Working...