98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting
Conditional Formatting
Resolved · Low Priority · Version 365
Tue 7 Feb 2023, 17:02Delegate Nick said...
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.
Fri 10 Feb 2023, 16:21Trainer Marius said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Freeze Rows and Columns to keep lables displayedYou can freeze rows and columns in your worksheet so they don't move. |
