+ Reply to Thread
Results 1 to 4 of 4

3 choices to change other cells color if matching condition

  1. #1
    Registered User
    Join Date
    03-02-2015
    Location
    ridgecrest, ca
    MS-Off Ver
    2010
    Posts
    54

    3 choices to change other cells color if matching condition

    I am having a brain fart here; I have a simple excel list of names that is being sent out to managers. I need them to mark 1 of 3 columns with an X, these columns are if an employee is going to leave in under 6 months, 6 to 12 months, and over 12 months. if they are under 6 months it turns there two name columns red, if its 6 to 12 months it turns the name columns yellow, and if its 12 or over it turns them green. I know this is stupid easy but again brain fart.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: 3 choices to change other cells color if matching condition

    Can you post your or even better:

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    03-02-2015
    Location
    ridgecrest, ca
    MS-Off Ver
    2010
    Posts
    54

    Re: 3 choices to change other cells color if matching condition

    KAHLE-raw.xlsx

    KAHLE-results.xlsx

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: 3 choices to change other cells color if matching condition

    Here's a quickie but it needs only anything in the "X" field:

    Please Login or Register  to view this content.

+ 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. color change for matching value cells
    By DanPop in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2016, 04:44 PM
  2. Risk Matrix to auto-fill color based on choices in two other cells.
    By EvalynT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2014, 06:28 AM
  3. Replies: 3
    Last Post: 01-08-2014, 03:56 PM
  4. [SOLVED] Change cell color once condition is met
    By miss_chloe in forum Excel General
    Replies: 10
    Last Post: 10-08-2013, 10:17 AM
  5. Condition Formatting: Change color when month change (oct = red, Nov = blue)
    By Flyinace2000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2012, 12:20 PM
  6. [SOLVED] Change Cell Color if Condition is Met
    By sourbeer in forum Excel General
    Replies: 1
    Last Post: 06-22-2012, 01:53 PM
  7. if condition to change cell color
    By pantea in forum Excel General
    Replies: 1
    Last Post: 02-09-2008, 05:16 AM

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