Hi everyone,
I’d like to add alternating colors to my spreadsheets. However, not every single row, but every pair of rows. e.g. rows 1+2 grey, 3+4 white, 5+6 grey, …
Thanks in advance!
Hi everyone,
I’d like to add alternating colors to my spreadsheets. However, not every single row, but every pair of rows. e.g. rows 1+2 grey, 3+4 white, 5+6 grey, …
Thanks in advance!
Using conditional format (Menu/Format/Conditional) with a formula like:
seems can do the job.
this did it, thank you!