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
Bookmarks