Seems like this should be easy but I'm having trouble figuring out. In column "A" I have a list that ascends by one. I want odd numbered rows to have a gray background and even rows to have no change. Here's what I'm trying to do:
A
1 (gray background)
1 (gray background)
2 (white background)
2 (white background)
2 (white background)
3 (gray background)
3 (gray background)
3 (gray background)
3 (gray background)
4 (white background)
4 (white background)
ect...
Thanks in advance!
Bookmarks