+ Reply to Thread
Results 1 to 2 of 2

Generating a result from Cell Color?

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    12

    Generating a result from Cell Color?

    Hi all,

    So I used conditional formatting to highlight some of my cells "RED" if the IF Function returns them as FALSE.

    Is it possible to write a formula that bascially states that if any of the 7 Cells are highlighted "RED", then a result of "FALSE" would be generated in another cell? If not, is there a way to bascially state that IF any of these 7 Cells are "FALSE", then the new cell result would also be "FALSE"?

    Thanks,

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Generating a result from Cell Color?

    Go with the FALSE, it's much easier to work with.

    Assuming you mean it must actually have "FALSE", and not just empty, then try something like:

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ 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. Result of two formulas (vlookup and Color) into one CELL
    By cybertaurean in forum Excel General
    Replies: 4
    Last Post: 10-10-2012, 03:32 AM
  2. Color cell based on vlookup value result
    By XCman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2012, 01:08 PM
  3. Excel 2007 : Result fixes cell color.
    By pawnraider in forum Excel General
    Replies: 1
    Last Post: 10-02-2009, 08:33 PM
  4. Result of IF conditional change cell color
    By Olasin in forum Excel General
    Replies: 1
    Last Post: 05-16-2006, 05:45 PM
  5. [SOLVED] How do I change the color of a cell depending on the result of the function in that cell
    By Mo Childs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-02-2005, 06: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