I have a dataset that has fixed data in the first 10 or so columns, then the rest of the columns are for user input. I have set conditional formatting on the user columns so that they are red for cells the user is allowed to use, and black for those they are not.
It is a large sheet, and being a noob, I was playing around and found the =MOD(ROW(),2)=1 formula to use conditional formatting to color every other row. Turns out that I like that. It works well on the fixed data portion, but when I try to use it for the rest of the page, it overrides the conditional formatting. I made one sheet work by manually selecting every other row, then setting the conditional formatting for all non-blank cells to be a certain color. Is there a way to highlight the entire user section and create a conditional formatting rule that will turn every other row a certain color for all non-blank cells only?
Bookmarks