Welcome Guest
Log In | Register )
You last visited December 6, 2016, 9:00 am
All times shown are
Eastern Time (GMT-5:00)

Excel and changing text color

Topic closed. 15 replies. Last post 4 months ago by gladys48.

Page 1 of 2
51
PrintE-mailLink
purplelover04's avatar - news
detroit,mi
United States
Member #42696
July 7, 2006
1158 Posts
Offline
Posted: August 7, 2016, 9:46 pm - IP Logged

I have copied all the number for my state in to excel and now i want to change the color of the text for each number but not do it by hand does anyone know how to do it or can it be done

Those who are the hardest to love usually need it the most

    TheMeatman2005's avatar - lightening
    Brooklyn, NY
    United States
    Member #169723
    October 29, 2015
    877 Posts
    Offline
    Posted: August 7, 2016, 10:46 pm - IP Logged

    I have copied all the number for my state in to excel and now i want to change the color of the text for each number but not do it by hand does anyone know how to do it or can it be done

    You can usually find instructions / directions to anything you want to do by Googgling it.

    I Goggled " How to changed text color in excel" and found a few sites.

    http://excel.tips.net/T002674_Changing_Font_Color.html

    https://support.office.com/en-us/article/Change-the-color-of-text-in-a-worksheet-eb648003-37d8-44ae-ba28-9378a410f9b1

    Hope this is what you're looking for

    The Meatman

    “The quickest way to double your money is to fold it in half and put it in your back pocket.” Will Rogers

    Winning happens in a flash, Like A Bolt Of Lightning!  Patriot

      helpmewin's avatar - dandy
      u$a
      United States
      Member #106665
      February 22, 2011
      19782 Posts
      Offline
      Posted: August 7, 2016, 10:50 pm - IP Logged

      You can usually find instructions / directions to anything you want to do by Googgling it.

      I Goggled " How to changed text color in excel" and found a few sites.

      http://excel.tips.net/T002674_Changing_Font_Color.html

      https://support.office.com/en-us/article/Change-the-color-of-text-in-a-worksheet-eb648003-37d8-44ae-ba28-9378a410f9b1

      Hope this is what you're looking for

      directions to anything you want to do by Googgling it.

      do they have directions on how to win the Lottery Red Devil

      Let it Snow Snowman

        TheMeatman2005's avatar - lightening
        Brooklyn, NY
        United States
        Member #169723
        October 29, 2015
        877 Posts
        Offline
        Posted: August 7, 2016, 11:32 pm - IP Logged

        directions to anything you want to do by Googgling it.

        do they have directions on how to win the Lottery Red Devil

        Yes, they even have that too. Try it. Google "how to win the Lottery"

        The Meatman

        “The quickest way to double your money is to fold it in half and put it in your back pocket.” Will Rogers

        Winning happens in a flash, Like A Bolt Of Lightning!  Patriot

          maxodds's avatar - max
          Jupiter, FL
          United States
          Member #154501
          April 18, 2014
          74 Posts
          Offline
          Posted: August 8, 2016, 3:43 am - IP Logged

          I have copied all the number for my state in to excel and now i want to change the color of the text for each number but not do it by hand does anyone know how to do it or can it be done

          When in excel, hold ctrl and the letter a, that will select all numbers, then go ahead and change it to the color you want.

          We could all win the lottery today!

            Avatar

            United States
            Member #41846
            June 23, 2006
            459 Posts
            Offline
            Posted: August 8, 2016, 5:18 am - IP Logged

            I have copied all the number for my state in to excel and now i want to change the color of the text for each number but not do it by hand does anyone know how to do it or can it be done

            look for the conditional formatting icon.  select your rule. depending on how involved you are getting with this a couple of things to consider. speed this will slow operation in your spreadsheet.  there is a limit to how many conditions you can use.  a choice could be macros if your color selections are more dynamic or you want to set lots of conditions. 

            more info on what you want to do will get you more exact answers.

              LiveInGreenBay's avatar - driver
              Green Bay
              United States
              Member #169391
              October 15, 2015
              1244 Posts
              Offline
              Posted: August 8, 2016, 8:03 am - IP Logged

              directions to anything you want to do by Googgling it.

              do they have directions on how to win the Lottery Red Devil

              Google... "Winning numbers for the next mega millions drawing".  Either that or just ask jj.

              Never give up.  Banana

                TheMeatman2005's avatar - lightening
                Brooklyn, NY
                United States
                Member #169723
                October 29, 2015
                877 Posts
                Offline
                Posted: August 8, 2016, 8:45 am - IP Logged

                Google... "Winning numbers for the next mega millions drawing".  Either that or just ask jj.

                Doing that would take the "excitement" out of the game. Would be neat though if they could do that.

                The Meatman

                “The quickest way to double your money is to fold it in half and put it in your back pocket.” Will Rogers

                Winning happens in a flash, Like A Bolt Of Lightning!  Patriot

                  purplelover04's avatar - news
                  detroit,mi
                  United States
                  Member #42696
                  July 7, 2006
                  1158 Posts
                  Offline
                  Posted: August 8, 2016, 5:09 pm - IP Logged

                  thanks for the help but I wanted to make all the 1 green and all the 2 red I was making list of VTracs for my state and to help me see whats missing the color helps 

                   

                  i just want to know if there is a shortcut to doing it

                  Those who are the hardest to love usually need it the most

                    notmyday's avatar - 8ball
                    florida
                    United States
                    Member #136668
                    December 16, 2012
                    334 Posts
                    Offline
                    Posted: August 8, 2016, 5:38 pm - IP Logged

                    thanks for the help but I wanted to make all the 1 green and all the 2 red I was making list of VTracs for my state and to help me see whats missing the color helps 

                     

                    i just want to know if there is a shortcut to doing it

                    if your numbers are in seperate cells you highlight all the cells then hit conditional formatting then on the drop down hit the top line which is highlight cell rules then on that you can hit text that contains click it and choose the number and color there this will highlight the entire cell not just the text. ok i just checked if you go there hit the custom format and the in there you can due text only and pit the colors.

                      notmyday's avatar - 8ball
                      florida
                      United States
                      Member #136668
                      December 16, 2012
                      334 Posts
                      Offline
                      Posted: August 8, 2016, 5:57 pm - IP Logged

                      if your numbers are in seperate cells you highlight all the cells then hit conditional formatting then on the drop down hit the top line which is highlight cell rules then on that you can hit text that contains click it and choose the number and color there this will highlight the entire cell not just the text. ok i just checked if you go there hit the custom format and the in there you can due text only and pit the colors.

                      i think this is what you want it worked on my sheet.

                        Sunglasses's avatar - nicebear
                        Zaperlopopotam
                        Belgium
                        Member #173932
                        March 26, 2016
                        952 Posts
                        Offline
                        Posted: August 9, 2016, 5:13 am - IP Logged

                        thanks for the help but I wanted to make all the 1 green and all the 2 red I was making list of VTracs for my state and to help me see whats missing the color helps 

                         

                        i just want to know if there is a shortcut to doing it

                        a)

                        Choose tab data.
                        Select your cells on the sheet.
                        Click on "text to columns".
                        Follow instructions on the form.

                        b)

                        Choose tab home.
                        Select your cells to format.
                        Conditional formatting.
                        New Formatting Rule.
                        Use a formula to ... .
                        Enter a formula.
                        Set the Format to apply.
                        Click ok to view the result.

                        Options:

                        Use the function mid instead of text to columns.

                        When it isn't a string, use cells.
                        Programmers can do otherwise.

                          Sunglasses's avatar - nicebear
                          Zaperlopopotam
                          Belgium
                          Member #173932
                          March 26, 2016
                          952 Posts
                          Offline
                          Posted: August 9, 2016, 5:25 am - IP Logged

                          directions to anything you want to do by Googgling it.

                          do they have directions on how to win the Lottery Red Devil

                          Type That's 149.99 USD for directions of system #045099.

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5387 Posts
                            Offline
                            Posted: August 9, 2016, 9:13 pm - IP Logged

                            I have copied all the number for my state in to excel and now i want to change the color of the text for each number but not do it by hand does anyone know how to do it or can it be done

                            Excel 2010

                            https://1drv.ms/u/s!AifgvyqwTTMrg0VYE5fmqCxy7I_y

                            1>Download the zip file from link above

                            2>Unzip the Excel file into a new folder or location of your choosing.

                            3>Open the Michigan Pick 4 Excel file

                            4>Click the tab labeled MI4C.  This worksheet has the winning Pick 4 draws through Tuesday August 9, 2016

                            Notice in cell ranges L20 through O119 (digits) and cell ranges S20 through V119 (Vtracs) all the digits are colorized according to their value

                            5>Click the tab labeled "ColorIndex"

                            6>Click the Toolbar labeled "Step 1 Click to Remove Colors"

                            7>Click the tab labeled MI4C.  Notice that all the digits are now un-formatted (no color)

                            8>You can add or delete draws in the MI4C worksheet by clicking the appropriate toolbars. Adding new draws only requires you to enter the winning Michigan Pick 4 drawing in cell F20.

                            9>Click the tab labeled "ColorIndex".  Click Step 2 Click to Colorize Digits. 

                            10>Click the tab labeled MI4C.  Notice that all the digits and vtracs are colorized.

                             

                            I currently have the total draws to colorize to 100 draws.  You can change the total draws by doing the following:

                            1>Click the tab labeled MI4C.

                            2>Change the value in cell B6 from 100 to whatever value you wish as long as it's not greater than the value in cell B20.

                             

                            If you wish to change the colors:

                            1>Click the tab labeled "ColorIndex"

                            2>In cell range D10 through F19 you can change the R-G-B values to the custom of you choice for digits 0 through 9.

                            3>In cell range G10 through G19 you can change if you want the digit to be bold by selecting 1=False or 2=True (Bold)

                             

                            Note: when adding new drawing make sure you remove the color from all the digits.

                              LottoBux's avatar - 2elh5if
                              Ontario
                              Canada
                              Member #109243
                              April 9, 2011
                              31437 Posts
                              Offline
                              Posted: August 10, 2016, 12:44 am - IP Logged

                              Yes, they even have that too. Try it. Google "how to win the Lottery"

                              Yes And So Many Programs To Buy,lol

                              You Could Be A Winner Very Soon....