Nick has attended:
Excel Intermediate course
Conditional Formatting
Hello.
I have a spreadsheet with some conditional formatting for a few cells in each row, not the whole row. When I add a new row to input more data, I have to keep adding the same conditional formatting for the new information.
Is there a way that this can be done automatically without having to keep adding it each time.
Many thanks.
RE: Conditional Formatting
Hello Nick,
Thank you for your question. Depending on your version of Excel, when you insert a new row directly below a row with conditional rules, Excel automatically copies the rules to the new row. This happens in the new version of Excel (365).
If this doesn't happen, you can select and copy the cells with rules, then paste formatting to the inserted row(s).
This will transfer the rules but won't duplicate the data.
I hope this helps.
Kind regards
Marius Barnard
STL