+ Reply to Thread
Results 1 to 5 of 5

change color of cells based on text in another

Hybrid View

Valleyboy change color of cells based... 08-23-2015, 01:30 PM
Pete_UK Re: change color of cells... 08-23-2015, 01:48 PM
JohnTopley Re: change color of cells... 08-23-2015, 01:57 PM
Valleyboy Re: change color of cells... 08-23-2015, 02:05 PM
Pete_UK Re: change color of cells... 08-23-2015, 03:51 PM
  1. #1
    Registered User
    Join Date
    08-23-2015
    Location
    alberta, canada
    MS-Off Ver
    2007
    Posts
    2

    change color of cells based on text in another

    Hey guys and gals,
    I'm a relative newbie to excel.
    I have a problem that I'm betting one of you can easily solve.
    I have one column where only the following words will ever be entered. : welder, carpenter, wash bay, and yard. This column is column H. I would like to change to color in the B cell in the same row each time one of these words is entered into a cell in column h.
    I would like this to work for the entire sheet.
    Is this possible? I have googled it and tried several options but I can't get any of them to work. I could be just a dummy. Please help!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: change color of cells based on text in another

    You can use conditional formatting for this. Highlight column B, then click on conditional formatting | New Rule | Use a formula... , and put this formula in the dialogue box:

    =$H1="welder"

    Click on the Format button, then the Fill tab and choose the colour that you want for this condition, then OK twice to exit the dialogue box. Repeat this for the other words, selecting a new colour each time.

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,687

    Re: change color of cells based on text in another

    Try this with Conditional Formatting

    Highlight B range==>Conditional Formatting==>New rule==>Use a formula ...==>enter formula below==> Format==> choose Colour ==> OK

    =AND(OR(H3="welder",H3="Carpenter",H3="Wash Bay",H3="Yard"),B3=H3)

  4. #4
    Registered User
    Join Date
    08-23-2015
    Location
    alberta, canada
    MS-Off Ver
    2007
    Posts
    2

    Re: change color of cells based on text in another

    Thank you so much guys I used Pete's and it worked great. And I'm sure John's would have worked as well.

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: change color of cells based on text in another

    Glad to be able to help.

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change text color of selected cells based on a text value of another cell
    By JNEWBURY2280 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2014, 11:26 PM
  2. change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  3. VBA to change font color of range of cells based on text not in another cell
    By tk31271 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2013, 09:36 AM
  4. change row color based on text
    By vbjohn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2011, 12:39 PM
  5. change text color based on background color
    By great.bean in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2009, 07:07 PM
  6. change text color based on adjacent cell text color
    By matthewst in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2005, 03:49 PM
  7. How to code so cells or text automatically change color based on .
    By lisamariehewson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1