Hi
I've currently creating a spreadsheet where some cells have conditional formatting. As this spreadsheet needs to constantly updated by various people, does anyone know if there is a way of creating additional rows without having to copy and paste the conditional formats from the previous row? e.g. a simple button at the end of the row? Do I need to use macro?
The spreadsheet will be shared with others and they're not familiar with conditional formatting, they may not know that they need to copy and paste the format if they were to add rows - so if there was a way to simply click a button at the end of the row to add a blank row below which will follow the same conditional format as the row above, that would be helpful?
Any advice would be grateful
I've currently creating a spreadsheet where some cells have conditional formatting. As this spreadsheet needs to constantly updated by various people, does anyone know if there is a way of creating additional rows without having to copy and paste the conditional formats from the previous row? e.g. a simple button at the end of the row? Do I need to use macro?
The spreadsheet will be shared with others and they're not familiar with conditional formatting, they may not know that they need to copy and paste the format if they were to add rows - so if there was a way to simply click a button at the end of the row to add a blank row below which will follow the same conditional format as the row above, that would be helpful?
Any advice would be grateful