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.
![03jiksgmwbla1.png](/board/proxy.php?image=https%3A%2F%2Fpreview.redd.it%2F03jiksgmwbla1.png%3Fwidth%3D114%26format%3Dpng%26auto%3Dwebp%26v%3Denabled%26s%3De5347b55e4bfed787a5eea9cb24d1b4226cbd4f9&hash=f84784780b7e8026289b841ca6a6b3b2)