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 ...
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.