+ Reply to Thread
Results 1 to 6 of 6

Cell Color change based off multiple cells conditional formatting

  1. #1
    Registered User
    Join Date
    08-19-2021
    Location
    Venice, Italy
    MS-Off Ver
    2016
    Posts
    14

    Question Cell Color change based off multiple cells conditional formatting

    Good morning community,

    I am still somewhat new to the community and excel using conditional formatting. I am currently using conditional formatting to highlight cells in a column for dates (ex. I input the date 1-Jan-2019 (cell turns red), 28-Aug-20 (cell turns yellow), 1-Jan-2021 (cell turns green). I have this down as it can be seen in the attachment.

    However I would like to highlight the persons name (2 cells, Last name, First name) when any cells in that row. So if the entire row of conditional formatting is green, the Both A2 and B2 will show green, and if any of the cells in the row turn yellow or red it will automatically highlight the name in A2 and B2 to show that corresponding color, (if it shows red and yellow, red should go to the top).

    I hope this is understandable and I hope someone is able to help me with the problem. Thank you and have a wonderful day!

    - GulonRaid
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Cell Color change based off multiple cells conditional formatting

    What color would you want the names, if D:E each have different colors?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-19-2021
    Location
    Venice, Italy
    MS-Off Ver
    2016
    Posts
    14

    Re: Cell Color change based off multiple cells conditional formatting

    So I would like if it is possible to go off a color coding. If it could read C through E, and check the conditional formatting, it would match the conditional formatting. So if Column C shows Red, Column D shows Yellow, and Column E shows green, it would show red that something is due. or if it only shows yellow and green in the data cells, it would show yellow. If it only shows green, then the names would just be green. Does this make sense or do I need to try and think of a better way of describing it?

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Cell Color change based off multiple cells conditional formatting

    iI wonder if there was a gap between today-30 and today? In sample, try input the yesterday (today-1), it will be no color? is it your expected outcome, or it should be green?
    Quang PT

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Cell Color change based off multiple cells conditional formatting

    I tried with your current set of condition.
    Stay in A2, highlight A2:B4, then apply 3 conditional formatting formulas, in order priority, with the option box "Stop if true" is chosen:
    For red: =OR(TODAY()-$C2:$E2>365)
    Yellow: =OR(TODAY()-$C2:$E2>335)
    Green: =OR(TODAY()-$C2:$E2>30)
    In case you want to extend the green into yesterday: Green: =OR(TODAY()-$C2:$E2>0)
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-19-2021
    Location
    Venice, Italy
    MS-Off Ver
    2016
    Posts
    14

    Re: Cell Color change based off multiple cells conditional formatting

    That worked perfect! Thank you so much!!!

+ 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. Use VBA to do conditional formatting- change column color based on cell value
    By Angle10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2019, 08:58 AM
  2. Replies: 2
    Last Post: 09-02-2018, 01:09 PM
  3. Replies: 5
    Last Post: 12-07-2013, 02:21 PM
  4. Replies: 3
    Last Post: 11-08-2013, 03:10 PM
  5. Replies: 10
    Last Post: 06-19-2013, 05:28 PM
  6. [SOLVED] 2010 Conditional Formatting: Cell Color Change, Based on Ratio (1:1)
    By James_D in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2013, 09:02 PM
  7. Replies: 5
    Last Post: 05-10-2012, 10:49 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