Hi all
I'm struggling with what is probably a simple task. I want to add a bottom border to every 5th row in my SS. I can do this easily enough by selecting the relevant range, going to conditional formatting and using =MOD(ROW(),5)=0 then applying the relevant format. However, I can't get it to ignore the first (header) row meaning that everything is out of sync. What's the solution?
Many thanks
Dave
Bookmarks