I was told in a course that I could use MOD() for Conditional formatting - shading every other row -- but wasn't told how. Can someone please tell me how to do this?
Go to conditional formatting and select the option to use your own formula. Paste that in and set your formatting.
MOD takes the remainder. This takes the row # divided by two, so even rows will have a remainder of 0, while odd rows will have a remainder of 1. All of the 1's get formatted and all of the 0's are blank.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.