How do I auto shade every other line in a form already in use

  • Thread starter Thread starter Guest
  • Start date Start date
Working with a copy of your file for practice.........you might try the
appropriate feature in the free add-in called ASAP Utilities. It's
available at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3
 
Select the range, then apply conditional formatting using the formula:
=MOD(ROW(),2)
Choose a nice fill colour, ok out
[/QUOTE]
Re: How do I auto shade every other line in a form already in use
 
Thanks, Martin. Your reply to my post was the most informative and to the
point, with a lot of additional capablilities I will now use.

Again, thanks!

Michael B
 
Thanks for the feedback, but the thanks should go to Bob Phillips;
I'm just the messenger.

Cheers
Martin
 
Back
Top