Skip to main content
Question Protected by CommunityBot
edited tags
Link
Jacob Jan
  • 23.4k
  • 16
  • 107
  • 197
Tweeted twitter.com/#!/StackWebApps/status/213308382550044672
Source Link
Phira
  • 561
  • 1
  • 4
  • 6

Alternating colors for lines in Google docs spreadsheet

I have a shared Google spreadsheet where several users have already filled out parts. It would be useful to have alternately colored lines to facilitate correct placement of additional data.

Is there a painless method option to alternately color (say, the cells given that already many of them contain text?

In an empty document, there would always be the "color 2 lines, copy-paste 2 lines, copy-paste 4 lines, etc." option, but in the current document, there is already text and some lines are still liable to be deleted which necessitates a recoloring later.