PDA

View Full Version : Solved: fill in every other row



tkaplan
04-02-2008, 06:54 AM
i used to know how to do this and now my brain has left me.
if i want to have every other row highlighted (yellow) and every other row remain white - so i know that it's conditional formatting looking at the row number i just cant remember how u check if the row number is even...
thanks!!!

tkaplan
04-02-2008, 06:58 AM
oh yay i figured it out!
MOD(ROW(),2)=0