Copy Conditional Formatting from Range to Another
Copy And Paste Conditional Formatting. Ctrl alt v ( paste special) > t (format) > ok. Use the keyboard shortcut ctrl+c on windows or command+c on mac.
Web click the copy button in the clipboard section of the ribbon on the home tab. Select the cells that you want to apply the rule to by. Ctrl c (copy) select target cell/range in sheet1. Use the keyboard shortcut ctrl+c on windows or command+c on mac. Ctrl alt v ( paste special) > t (format) > ok.
Ctrl alt v ( paste special) > t (format) > ok. Web click the copy button in the clipboard section of the ribbon on the home tab. Select the cells that you want to apply the rule to by. Ctrl c (copy) select target cell/range in sheet1. Use the keyboard shortcut ctrl+c on windows or command+c on mac. Ctrl alt v ( paste special) > t (format) > ok.
