Conditional formatting
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 |
Conditional formatting
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 |
All times are GMT +1. The time now is 06:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com