Forum Discussion

Hamid51's avatar
Hamid51
Copper Contributor
Aug 30, 2022

Redo conditional formatting

How can I repeat conditional highlighting to several rows? I have written a rule applied to a

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Hamid51 

    Copy conditional formatting

    Quick Reference Guide
    Open the document and select the cells to be transferred to a new range of cells including the format.
    Right-click to open the menu and select "Copy".
    Now click on the first cell for the target range.
    Right-click again and select the first option under "Paste".
    You transferred the format to a new range of cells.

     

    ...or

    Apply Conditional Formatting For Each Row In Excel

    a non-Microsoft internet site, without warranty.

Resources