+ Reply to Thread
Results 1 to 4 of 4

Change Txt Color Based on another Cell info containing Letters & numbers

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Question Change Txt Color Based on another Cell info containing Letters & numbers

    Need Help I have a spreed sheet that had a list of street names in column B and there assign routes numbers in column A. What i am trying to do is i want column A & B to change the font color to read based on the info in column A. But the trick is that the info in column A contains both letters and numbers. And i can get it to work when it has just on or the other not both. Because what is happening is these route that we read meters on everyday some of the meters are changing and we want to show on the spreed sheet witch routes has the new style meters on it, so in column A would change from just showing a number "1" to showing "AMR-1" in the column. And when Column A has the AMR added to the Route # that's when I want the Font color of both A & B to turn Red.

    WHAT THE SPREED SHEET STARTS OUT AS WHAT THE SPREED SHEET GOING TO LOOK LIKE

    Here is an Example
    Column A Column B Column A Column B
    1 Street A AMR - 1 Street A This is when i want it to change to Red
    2 Street B 2 Street B
    3 Street C 3 Street C
    4 Street D AMR - 4 Street D This is when i want it to change to Red
    5 Street E 5 Street E


    Thank you for your Help

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Change Txt Color Based on another Cell info containing Letters & numbers

    Hi
    You can use conditional formatting..
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Check the attached file..
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  3. #3
    Registered User
    Join Date
    09-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Change Txt Color Based on another Cell info containing Letters & numbers

    Sweet thank you that did it

  4. #4
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Change Txt Color Based on another Cell info containing Letters & numbers

    Thanks for the feedback..

+ 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. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  2. [SOLVED] VBA to select a range and change text color within row based on info in specified column
    By Chris S. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2013, 09:05 PM
  3. Need to change cell color based on info in other cell
    By waki01 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-13-2009, 02:54 PM
  4. Replies: 5
    Last Post: 04-27-2006, 04:55 PM
  5. Set color of cell based on info on another sheet?
    By 43fan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2005, 03:55 PM

Tags for this Thread

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