Format only visible rows in Conditional Formatting with an active filter.
How can I modify this formula to only format visible rows when a filter is applied in Conditional Formatting?
The formula is currently:
=AND(COUNTIFS($F$4:$F4,$F4)=1,MINIFS($F$4:$F4,$F$4:$F4,">="&$F4-WEEKDAY($F4,3))=$F4)
The objective is to highlight the first Monday date or the next closest date after Monday in column F. The range of dates in column F varies in start date and length and may not always start on a Monday. Additionally, the range may have skipped dates and duplicate dates following each other. The formula should only highlight one cell per week.
How can I modify this formula to only format visible rows when a filter is applied in Conditional Formatting?
The formula is currently:
=AND(COUNTIFS($F$4:$F4,$F4)=1,MINIFS($F$4:$F4,$F$4:$F4,">="&$F4-WEEKDAY($F4,3))=$F4)
The objective is to highlight the first Monday date or the next closest date after Monday in column F. The range of dates in column F varies in start date and length and may not always start on a Monday. Additionally, the range may have skipped dates and duplicate dates following each other. The formula should only highlight one cell per week.