Forum Discussion
copy command
Hello, I am a business user. I am trying to copy this command to the other rows. I created a data validation and rules. The rules, it makes me make a new rule for every row. I am trying to copy ...
Not sure what exactly you'd like to copy. Perhaps conditional formatting rule which highlights another row. At the same time it's not clear why do you need to copy such rule. In general you have two colors (formatting), thus you need only two conditional formatting rules applies to entire range.
Or you would like to apply data validation to the cell(s) in new rows?
SergeiBaklan I am having difficulty applying the range and making it for the whole column
If that's conditional formatting you may apply rule as
Apply it to you entire range. In formula B is the column with drop-downs and range starts from row #1. When we use $B1. Be sure for the row we take relative reference and for the column absolute one.
