To copy conditional formatting in Google Sheets, follow these steps:
1. Click the Cells tab and select the cell or cells you want to Format.
2. Underneath “Conditional Formatting”, click the “Format…” button.
3. On the Conditional Formatting pane, select “Copy Settings” from the top left corner and choose which columns you want to include in your formatting. NOTE: if you only need to format one column and not all of them, just check the box next to that column instead of selecting all of them (this will help save precious time!).
4. To apply your new formatting, click the blue text with a yellow stri