DPChristman
Board Regular
- Joined
- Sep 4, 2012
- Messages
- 171
- Office Version
- 365
- Platform
- Windows
I have a large spreadsheet, encompassing.
I am using conditional formatting to highlight locations in excess of a preset threshold.
All of the locations are divided by several hundred districts, and between each district group there are three blank rows.
One of these rows will contain the total for that district
This row cannot have the same conditional formatting as the individual locations, because the district totals would erroneously be highlighted as exceptions.
What I am looking for is a simple way to copy and paste the same district level formatted formula line repeatedly over hundreds of row gaps,without having to do it manually.
Due to regularly shifting district alignment and distribution requirements, I cannot use SUBTOTAL or Pivot tables to accomplish this.
Basically looking for a lazier copy and past option other than line for line.
I am using conditional formatting to highlight locations in excess of a preset threshold.
All of the locations are divided by several hundred districts, and between each district group there are three blank rows.
One of these rows will contain the total for that district
This row cannot have the same conditional formatting as the individual locations, because the district totals would erroneously be highlighted as exceptions.
What I am looking for is a simple way to copy and paste the same district level formatted formula line repeatedly over hundreds of row gaps,without having to do it manually.
Due to regularly shifting district alignment and distribution requirements, I cannot use SUBTOTAL or Pivot tables to accomplish this.
Basically looking for a lazier copy and past option other than line for line.