+ Reply to Thread
Results 1 to 6 of 6

Conditional Format color of cell based on values in a range of cells

  1. #1
    Registered User
    Join Date
    10-24-2013
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Conditional Format color of cell based on values in a range of cells

    I would like to format the color of cell A1 on Sheet 1 based on true or false values from cell range A1:A10 on sheet 2. For instance:

    1. If all cells on sheet 2 in range A1:A10 were false then cell A1 on sheet 1 would be red.
    2. If some cells on sheet 2 in the range A1:A10 were false and some were true then cell A1 on sheet 1 would be yellow.
    3. If all cells on sheet 2 in range A1:A10 were true then cell A1 on sheet 1 would be green.

    Thank you for your assistance.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Conditional Format color of cell based on values in a range of cells

    See the attached sampple
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-24-2013
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Conditional Format color of cell based on values in a range of cells

    Thank you Mehmetcik for your reveiw of my problem. I apologize if I am just getting it but, I looked at your sample and am not comprehending how it solves for partial true values in the range changing the color to yellow or all true values changing the color to green.

    Thanks

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Conditional Format color of cell based on values in a range of cells

    Try this conditional formatting:
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Registered User
    Join Date
    10-24-2013
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Conditional Format color of cell based on values in a range of cells

    Newdoverman, AWESOME! Exactly what I was looking for. Thanks a bunch.

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Conditional Format color of cell based on values in a range of cells

    Great! Thanks

+ 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. change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  2. How to Color Format a Range Based on the Cell Value-- Using VBA
    By AGALLEGOS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2014, 02:03 AM
  3. Conditional format to change color of row based on data in cell
    By PJenkins in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2013, 09:39 AM
  4. [SOLVED] Change conditional format (color) of a cell based on another celll (Excel 2010)
    By ffnptown in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2012, 09:50 PM
  5. [SOLVED] Conditional Format cell based on value of cells in range
    By Dean81 in forum Excel General
    Replies: 5
    Last Post: 03-20-2012, 12:20 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