I have an extensive spreadsheet of data and I would like to highlight every other row with a specific color. I have no problem doing so with the following conditional formatting statement:
However, I frequently sort and hide rows and when doing the rows do not highlight properly and eventually I am having to manually color them. Are there any ways to achieve what I am wanting?Please Login or Register to view this content.
Thanks
Bookmarks