I have a large sheet with dates in column A in ascending order. There can be multiple rows with same date. I need to conditional format (mark) the row containing either todays date or if not found, the immediate previous row. If the previous rows contain the same date value, it should mark the last of them, not the first.
I have tried to do it with MATCH() but I cannot work out how to use the row number in conditional formatting.
Thanks in advance
Håkan

Forget the problem: It helped to write it down. I found the solution:
=ROW()=MATCH(TODAY(),$A:$A)
Håkan