Conditional Format (Rules) changing order when copied

Snake Eyes

Board Regular
Joined
Dec 14, 2010
Messages
103
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Greetings,
I have rows that have conditional formats based on the value of one cell in that row.
There are cells within that row that have their own conditional formats (Column applied Rules.)

I want to copy the rows formats to other rows in the sheet and keep the same order of the Rules (Conditional Formats) however, every time I copy then paste the formats, the order of the rules changes. The rules that apply to the entire row are moved up to the top of the list which gives the priority over the individual column based cell formats. (See screenshots.)
How do I prevent this re-ordering?

First Image is the Original Order of the rules...
Original Order.png


This is after copying the row formats and pasting them to a blank row...
After Row Copy.png
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
I wanted to follow up and advise that this behavior is seen in Excel 365 and not in 2016 or 2019.
This then seems to be a bug in Excel 365.
 
Upvote 0
This then seems to be a bug in Excel 365.
Do you have a source that mentions this is a bug? A Microsoft page or an online discussion somewhere else. If so, please post it, and then you can mark that post as the answer to lead future readers to a possible solution. Otherwise, there might be others who know about this issue or it might be something else that someone else can explain. Keeping the thread without marking a post as the solution will help them to see your question and share their knowledge on the issue. That's why I removed the solution mark.
 
Upvote 0
I don't have a reference to use that backs up my assertion.
I simply try the format copy in 365 and the issue appears.
I close the document and open it in 2019 and then again in 2016 and do the same process and the issue does not present itself.
I.e. the format copy works as it should.
 
Upvote 0
I don't have a reference to use that backs up my assertion.
I simply try the format copy in 365 and the issue appears.
I close the document and open it in 2019 and then again in 2016 and do the same process and the issue does not present itself.
I.e. the format copy works as it should.
Right, that's what I am saying. Perhaps someone has a perfect explanation for the question or a reference that explains the bug as you think (this might happen tomorrow or next year), so they can see this question doesn't have an actual answer and let us know what they know that will make this thread more useful to future readers.
 
Upvote 0

Forum statistics

Threads
1,214,987
Messages
6,122,618
Members
449,092
Latest member
amyap

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top