L R Copy Format | In Excel ~repack~

Choose your . By default, Excel overwrites your original data. Change this destination to an empty adjacent column to preserve your source data.

If your leftmost column contains conditional formatting based on a formula, ensure your row or column anchors ( $ ) are set correctly so the logic scales accurately as you copy it to the right. l r copy format in excel