Snake Eyes
Board Regular
- Joined
- Dec 14, 2010
- Messages
- 103
- Office Version
- 365
- 2016
- Platform
- 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...
This is after copying the row formats and pasting them to a blank row...
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...
This is after copying the row formats and pasting them to a blank row...