Excel: Copy conditional formatting completely to other cells
The previously cumbersome copying of conditional formatting from one cell to another has been very easy since Excel 2010.
Transfer conditional formatting to Excel
- Right-click in the cell whose conditional formatting you want to copy and select the context command »Copy«.
- Then right-click in the target cell and open »Insert content | Insert content «.
- In the following dialog of the same name, activate the option »All merging conditional formats« and confirm with »OK«.
By the way: The conditional formatting may only contain addresses fixed with "$", which should also remain unchanged at the destination. Excel determines non-fixed addresses relatively, ie starting from the cell with the conditional formatting.