VBA for Highlighting

[dkz3r0]

I am trying to create a Macro that allows me to highlight every 5th (or 65th) row of a spreadsheet.

Could a similar macro be used to highlight every 5th (or 65th) column?

I am definitely new to creating the macros, so any utility that can assist me to assist myself in the future would be awesome.


Thanks

[Bob Phillips]

You don't need VBA, just use conditional formatting with a formula of

=MOD(ROW(),5)=0

[dkz3r0]

Awesome.. thanks!