+ Reply to Thread
Results 1 to 3 of 3

Formula to change the text color of a row

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    Republic, MO
    MS-Off Ver
    Excel 2011 & Excel 2004
    Posts
    2

    Formula to change the text color of a row

    I want to change the text color of a row based on the initials of a salesperson. Example: the row that JH sold to be Brown, row that AGW sold to be Purple, row that DAB sold to be Blue, ect. Is there a way to do this. Thanks

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Formula to change the text color of a row

    when you invoke conditional formatting, choose Use a formula to determine which cells to format.. then in the formula, anchor the column that the check value is in so all cells in the row point to it.

    e.g.

    If the data is in A1:D50, and the names are in A1:A50, then select the whole range, invoke conditional formatting as above, enter formula like: =$A1="JH" then click Format and choose from Font tab. Click Ok, then click New Rule and continue on...
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    05-15-2012
    Location
    Republic, MO
    MS-Off Ver
    Excel 2011 & Excel 2004
    Posts
    2

    Re: Formula to change the text color of a row

    Thank you!!! That worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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