Here is the data validation rule I have:
I want that formula to be applied to the next 100 rows. Here's the process I’m following:
When I follow this process, the second "applies to" range is S105 in all rows. For example, in row 10, I get the data validation:
But I want it to apply to: =$A$7:$S$7
- Format values where this formula is true: =$BK$6="W"
- Applies to: =$A$6:$S$6
I want that formula to be applied to the next 100 rows. Here's the process I’m following:
- Select Range A6 to Range S6
- Copy
- Select Range A7 to Range S105
- Paste Special (formats)
When I follow this process, the second "applies to" range is S105 in all rows. For example, in row 10, I get the data validation:
- Format values where this formula is true: =$BG7="W"
- Applies to: =$A$7:$S$105
But I want it to apply to: =$A$7:$S$7