+ Reply to Thread
Results 1 to 2 of 2

Why doesn't this conditional formatting formula in Excel 2007 work?

  1. #1
    Registered User
    Join Date
    04-23-2014
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    3

    Why doesn't this conditional formatting formula in Excel 2007 work?

    This is the formula:

    =OR(AND(min_rankning_1="bergsäker vinnare"; Välj_rankningstabell="Min rankning");
    AND(fackpressens_rankning_1="bergsäker vinnare";Välj_rankningstabell="Fackpressens rankning"); AND(ATG:s_rankning_1="bergsäker vinnare"; Välj_rankningstabell="ATG:s rankning"))

    Explanations:
    min_rankning_1: A named cell on tab B which contains a drop-down list with 11 options (one option is "bergsäker vinnare")
    Välj_rankningstabell: A named cell on tab A which contains a drop-down list with 20 options (among them, for example, "Min rankning", "Fackpressens rankning", "ATG:s rankning", etc.).
    fackpressens_rankning_1 and ATG:s_rankning_1: same as for min_rankning_1 (see above).

    Only this formula works (but it's not sufficient, I need the combined OR AND):

    =AND(min_rankning_1="bergsäker vinnare";Välj_rankningstabell="Min rankning")

    On tab A, there is a drop-down list in H2 with 20 options. Then there are cells H5 to H19 where I need this conditional formatting formula so that if a certain option (e.g. "bergsäker vinnare") has been selected for a certain named cell in one of the 20 tables on tab B and at the same time this table name (e.g. "Min rankning") has been selected in H2 on the current tab A, then the background colour should change to dark blue.

    Here is a screencast of tab A ("Hästnamn" means "Horse name" and "Lopp 1" means "Race 1"; the context is an Excel for handicapping harness races):

    http://screencast.com/t/lsLAztjj

    And a screencast of tab B:

    http://screencast.com/t/OwynpYGG1YLL

  2. #2
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Re: Why doesn't this conditional formatting formula in Excel 2007 work?

    in my experience, functions are separated by "," and not ";" It might not be the case if you are using a non-english version of excel, not sure.
    However, it is far more helpful if you upload a file instead of screenshots. This can be done by editing your post (or making a new one) and clicking the Go Advanced button. After that, scroll down to the bottom and click Manage Attachments. From there attach your sample sheet.

+ 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. Replies: 6
    Last Post: 02-28-2014, 07:12 AM
  2. Conditional Formatting doesn't work after copy and insert
    By amarus99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 02:52 PM
  3. Excel 2007 : AND doesn't work in Conditional Formatting
    By cellarir in forum Excel General
    Replies: 2
    Last Post: 03-21-2012, 06:10 PM
  4. Conditional formatting applied to a pivot table doesn't work as it should
    By Pichingualas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2012, 07:43 AM
  5. Replies: 3
    Last Post: 05-05-2010, 04:25 AM
  6. Replies: 3
    Last Post: 09-09-2009, 03:35 PM
  7. Excel 97 formula doesn't work in Excel 2007
    By Divius in forum Excel General
    Replies: 4
    Last Post: 12-29-2007, 05:47 PM
  8. Replies: 0
    Last Post: 02-10-2005, 02:46 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