+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting based on two columns with four possible results

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Belgrade
    MS-Off Ver
    MS Office 2016
    Posts
    21

    Conditional formatting based on two columns with four possible results

    Hi all
    Can someone help me with conditional formatting:
    i have three columns: 1. main value, 2. value #1, 3. value #2
    column 1. has main values, columns 2. and 3. can have values same as column 1. but if column 2. has value then column 3. shall not have it and vice versa.

    i would like to use conditional formatting on 2. and 3. column that would color them if values in 2. and 3. differ from 1. column but that it wouldn't color them if there's value in the other column of those two (2. and 3.)
    for example:
    1.main value 2.value #1 3.value#2
    1..................1.............................-> both 2. and 3. should be without color (because there is value in 2. and its same as main value)
    2...................................2............-> both 2. and 3. should be without color (because there is value in 3. and its same as main value)
    3...................1............................-> 2. should be colored and 3. should be without color (because there is value in 2. and it differ from as main value)
    4...................................1............-> 2. should be without color and 3. should be colored (because there is value in 3. and it differ from as main value)
    Last edited by gesaugen; 02-16-2016 at 05:45 AM.

  2. #2
    Forum Contributor
    Join Date
    02-07-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: Conditional formatting based on two columns with four possible results

    Hi @gesaugen

    Can you post a sample file with enough data and expected output?

    Regards

  3. #3
    Registered User
    Join Date
    02-09-2015
    Location
    Belgrade
    MS-Off Ver
    MS Office 2016
    Posts
    21

    Re: Conditional formatting based on two columns with four possible results

    i would but i can't use attach function on this forum, and whole page crashes when i try to. it could be something with java part of website...

    but no matter, i've solved it. formula is:
    and(a1<>a2;a2<>"") for 2. column "value #1"
    and(a1<>a3;a3<>"") for 3. column "value #2"

  4. #4
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Conditional formatting based on two columns with four possible results

    It's not Java. I don't have it on my computer & can upload files with no problem

+ 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 Columns Based On Row Results
    By Kabukibear in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2015, 06:35 AM
  2. Conditional Formatting based on few columns
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2014, 04:11 AM
  3. Conditional formatting based on other results from other sheets......
    By Samba Glee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2013, 02:20 PM
  4. Replies: 2
    Last Post: 10-16-2012, 04:20 PM
  5. Replies: 12
    Last Post: 05-16-2012, 08:39 AM
  6. Conditional formatting based on two cell results
    By Molecheese in forum Excel General
    Replies: 2
    Last Post: 05-07-2009, 04:23 AM
  7. [SOLVED] CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL
    By jpreman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2006, 11:10 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