Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formating with isodd and iseven | Excel Worksheet Functions | |||
ISODD and EVEN formula | Excel Worksheet Functions | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
ISEVEN | Excel Worksheet Functions | |||
IF and ISODD Formula Help | Excel Worksheet Functions |