View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tskogstrom tskogstrom is offline
external usenet poster
 
Posts: 92
Default Identify even (or odd) rows without toolpak and 'ISEVEN'/'ISODD' ?

Hi,

I intend to have every even or odd row in another color, using
=iseven(row()) as conditionformat. However, i've learned that ISEVEN
demand the add-in Analysis Toolpak and I don't want that (of different
reasons).

Therefore - can someone find out a way to identify even or odd rows
without iseven/isodd function?

I can't have supporting cells on columns to the right becauser users
can add rows and if so, i can't build it on referring to other cells.

Happy to all suggestions,
Regards
tskogstrom