+ Reply to Thread
Results 1 to 3 of 3

Formula to read code in Column D, then apply color to columns a, b, c?

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    2

    Formula to read code in Column D, then apply color to columns a, b, c?

    On a sheet with 575 lines, I need to enter a formula, probably in column E, which will look at the code in Column D, then format the color of columns A, B, C. The code could be any one of 7 codes, 1a, 1b, 2a, 2b, 3a, 3b, N/A. The goal is to have all lines that have 1a in column D be one color (pink), all lines with 1b in column D be one color (green), and so on.

    I do not have enough experience with IF or LOOKUP to figure this one out on my own, and would appreciate being pushed in the right direction for any on-line reading materials relating to this type of formula.

    Thank you.

    Lor

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,330

    Re: Formula to read code in Column D, then apply color to columns a, b, c?

    You can't change the colour of a column with a formula, per se. What you need to look at is Conditional Formatting. Assuming that your data starts in row 2, select A2 down to the end of column C.

    Then select Conditional Formatting, New, Formula and use the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and format with the colour of your choice.

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-28-2014
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Formula to read code in Column D, then apply color to columns a, b, c?

    I'll get a chance to try this tomorrow. Thank you for the quick response.

    Lorann

+ 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. Excel VB: How do I apply a VBA code to one column only
    By hasanahmad in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2013, 10:03 AM
  2. [SOLVED] How to apply VBA code to more than one column
    By jewellove in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2013, 03:02 AM
  3. [SOLVED] Code is not making cells with no color filled. Can not apply NO FILL to spreadsheet.
    By Flowerski in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-01-2012, 08:35 AM
  4. Apply color code to only 3 columns of filtered range
    By hutch@edge.net in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-08-2009, 11:10 AM
  5. apply color to a cell using a formula
    By planchao in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-13-2008, 03:24 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