muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
Hi,
I have the traditional conditional format for finding duplicates using the formula rule in conditional formatting "=COUNTIF($A$4:$A$3000,$A4)>1". Is there a way to make this dynamic where it fits the data that varies month to month. As it currently is, all rows are highlighted below the last row of valid data and it's just bugging me . This month filled to row 259 but last month it filled to row 1267 and will vary each month.
I have the traditional conditional format for finding duplicates using the formula rule in conditional formatting "=COUNTIF($A$4:$A$3000,$A4)>1". Is there a way to make this dynamic where it fits the data that varies month to month. As it currently is, all rows are highlighted below the last row of valid data and it's just bugging me . This month filled to row 259 but last month it filled to row 1267 and will vary each month.