| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
