ExcelBanter - how do i copy format which refers to every OTHER cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i copy format which refers to every OTHER cell (https://www.excelbanter.com/excel-worksheet-functions/25699-how-do-i-copy-format-refers-every-other-cell.html)

selva

how do i copy format which refers to every OTHER cell

The formulas in my worksheet need to refer to every OTHER cell in another
sheet. How do I copy this function without manually enterring every other
cell?

All times are GMT +1. The time now is 12:40 PM.