Match multiple columns TODAY()+1 problem

Hi everyone

I have the following problem that I am unable to understand and solve.

I have a conditional formatting like this:

=INDEX($B2:$Z2, MATCH(TODAY(), $B$1:$Z$1, 0)) = "x"

If, e.g. the cell D20 displays an x AND the date in D1 is today's date, the function will color the cell in A20 red.
This works perfect so far.
The sheet contains:

A1:A50 := cells to color
B1:BXX1 := the dates
B2:BXX50 := empty cells which may contain an x

Now, I was thinking to make it a little more complex.

I want that A20 turns red, only if there is an x in D20 and an x in D21. Meaning, an x for today and tomorrow.
That is a problem of multiple columns that I tried to solve like this:

=INDEX($B10:$Z10; MATCH(1; (TODAY() = $B$1:$Z$1)*(TODAY()+1 = $B$1:$Z$1); 0)) = ""

If I delete the +1 the function works just fine.
If I leave it there excel returns #N/A

How could I solve this issue without implementing any VBA code?

Thanks in advance

Do it like this:

=AND(INDEX($B2:$Z2,MATCH(TODAY(),$B$1:$Z$1,0))="x",INDEX($B2:$Z2,MATCH(TODAY(),$B$1:$Z$1,0)+1)="x")

although the Z should be BXX.

Hope this helps.

Pete

Ok, I see.

It is best to work with AND here.
Cool.

Thanks for everything Pete, you have showed me a great deal of this tool in a very short time.

Cheers

You use AND because there are two conditions, both of which have to be satisfied, i.e. x in today's cell AND x in tomorrow's cell.

Pete