How to duplicate (not extend) conditional formatting rule?
- Click any cell covered by the original conditional formatting
- In the menu, pick format/conditional formatting...; this opens a side panel with all conditional formats that apply to that cell
- Click the format you want to duplicate
- Do not edit anything yet
- Click "Add another rule" on the bottom. This will save any changes you made to your original format ... and open a new clone.
- Change the range on the newly created clone.
- Repeat 5 and 6 until you enter the last range
- Click "Done".