Forumlas that have shading to alternate every other row which also update when rows are deleted/adde
I did use a pair of formulas based of digging I did on the forum, both a =ISODD and =MATCH, with an AUTOID column, but I think I'm making it harder.
This sheet is based off a form which will add a row per submission. I'm wanting to alternate the shading every other row via conditional formatting, which it updating when rows are added/deleted.
I had the auto-number column, plus 2 additional columns for the other formulas but I am lost somewhere. Please assist and thank you in advance!!!
Help Article Resources
Check out the Formula Handbook template!