+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting based on conditional formatting of other cells?

  1. #1
    Registered User
    Join Date
    09-18-2013
    Location
    USA
    MS-Off Ver
    2010
    Posts
    29

    Conditional formatting based on conditional formatting of other cells?

    Hi. Basic question here. Is there any way to set up conditional formatting in a cell to be based on the conditional formatting of multiple other cells?
    I would like the cells in column A to turn orange, yellow, red or green based on the color of the cells on the same row in columns B-F, which are colored based on conditional formatting.
    If none of the cells in B-F are green, then it would turn the cell in A red.
    If one of the cells in B-F are green, then it would turn the cell in A orange.
    If two of the cells in B-F are green, then it would turn the cell in A Yellow.
    If three or more of the cells in B-F are green, then it would turn the cell in A green.

    Is this possible? Thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,998

    Re: Conditional formatting based on conditional formatting of other cells?

    Hi and welcome to the forum

    Excel cannot "see" colors, so it cannot use colors for any formulas However, you obviously have rules for the 1st set of CF, Im sure we can wiggle them around a bit so that we can apply them for the 2nd set of CF?
    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

+ 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. Conditional Formatting Based on Value of Two Cells
    By Hillbilly-Highlander in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-12-2013, 03:51 PM
  2. Conditional Formatting Based on if two cells have same value?
    By peakoverload in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2012, 09:14 AM
  3. [SOLVED] Conditional formatting based on another cells value
    By Mistweaver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2012, 12:17 AM
  4. Replies: 4
    Last Post: 01-06-2012, 05:07 PM
  5. Conditional Formatting Based on Several Cells
    By dlvgolf in forum Excel General
    Replies: 2
    Last Post: 09-12-2008, 03:58 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