Forum Discussion
How to repeat same number every n rows in the same column
Hi, I need to repeat the same number every n rows within the same column, any thoughts? Also, how can I do the same using a formula rather than a number? Also, and I think , slightly mor...
castre1984 hello, easiest is to use if function along with mod to make repeated pattern, then for colors use conditional formatting with formulas
attached sample, hope this helps
You shall insert the value in every 12th cell (5th in your case) without touching values in the cells in between. =$I$15 could work, but I'm not sure what are limitations.
Colors is another question, these are using of different formulas depends on cell color.