PDA

View Full Version : VBA for Highlighting



dkz3r0
04-20-2011, 11:08 AM
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
04-20-2011, 11:18 AM
You don't need VBA, just use conditional formatting with a formula of

=MOD(ROW(),5)=0

dkz3r0
04-20-2011, 11:27 AM
Awesome.. thanks!