Hello,
I know the basic formula to shade every other row, but can it be altered if only data is in the column A of the row?
thanks for help on this.
Nick
Hello,
I know the basic formula to shade every other row, but can it be altered if only data is in the column A of the row?
thanks for help on this.
Nick
Use AND to combine A2<>"" with what you've got.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello TMS,
Thank you for the quick reply.
I am using =MOD(ROW(),2)=0
How could I incorporate that?
Thanks, I appreciate your help.
Hello,
Follow up, I was able to use this:
=ISEVEN(ROW())*OR($A3:$C3<>"")
Thank you for your help.
You're welcome.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks