Forum Discussion
Excel color-coding conditional formatting interuption
I have a spreadsheet in which I copied and pasted some data (apparently without formulas) and now all data I enter into the file is no longer color coded according to its conditional formatting (even though I tried to pick up where I left off and the formatting was still applied). Online, I read that you should be able to create a new rule based on one already used in the spreadsheet by selecting the previously used rule and clicking on duplicate (then applying this to a selection; i.e.- the rest of the document), but I did not see "duplicate" anywhere. Someone please help. I don't understand why I can't just select all the rules that are currently applied to the first portion of the spreadsheet and apply them to the remainder of it?! -ugh
B. Bookshar
Duplicate Rule is here
If you click on it you'll have exactly the same rule applied to the same range which you may edit. Option exists not for all versions of Excel.
If you copy/paste the range in general applied formatting also shall be pasted. If not you may select source range, right click and double click on Format Painter icon
Brush icon will appear near mouse pointer. Click on the first cell of destination range, format will be applied. Press Esc to exit from Format Painter mode.
5 Replies
Did you try to apply formatting with Format Painter?
Duplicate Rule is relatively new functionality, but it's simply duplicate existing rule as it is, after that you may edit it.
Thanks for your response. I did not try format painter & wouldn't even know how to begin using that?Also, I could never find the option to duplicate the pre-existing rules in the worksheet. I can only find where they are applied and where they aren't in "Manage Rules" - no option to duplicate existing rules in (create) New Rule either(?) SergeiBaklan
Duplicate Rule is here
If you click on it you'll have exactly the same rule applied to the same range which you may edit. Option exists not for all versions of Excel.
If you copy/paste the range in general applied formatting also shall be pasted. If not you may select source range, right click and double click on Format Painter icon
Brush icon will appear near mouse pointer. Click on the first cell of destination range, format will be applied. Press Esc to exit from Format Painter mode.
