Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.
Copy And Paste Conditional Formatting. 2 Copy and paste special Do this when the destination cells are not empty. Click on Edit.
Select the range whose conditional formatting you will copy and click Home Format Painter. Copy formula and click OK. Then do the same thing for B3Y3 B5Y5 etc.
Learn how to copy and paste conditional formatting rule from one cell to another cell.
Select the visual that already has the desired formatting options settings. Copying Conditional Formatting - YouTube. Copy formula and click OK. Or for your case it looks like you want the top row of each pair to use one format and the bottom to use another.