Joe Smith wrote:
Harold Fuchs wrote:
...
I've played with conditional formatting using =STYLE(IF(2*(INT(ROW(A1)/2))=ROW(A1); "Grey"; "Default")) but any actual values in the cells get wiped away (set to 0) when I apply this. I can't see how to get any further. I also can't see how to have it applied automagically when I insert a new row.

Does this help?

http://www.oooforum.org/forum/viewtopic.phtml?t=52166

<Joe
Yes :-) Thank you. Also, "iseven()" is a lot simpler than my convoluted formula which did the same thing ...

--
Harold Fuchs
London, England
Please reply *only* to [email protected]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to