• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Zebra lines at only visible lines

hilcom

New Member
We already saw how to make zebra lines (conditional formatting)

Now I want to filter records in a certain colom and still have remaining on/of zebra lines. The formula using =mod(row();2)does not work because it takes alle rows, not only visible. Anyone?

hilcom - Bob, Netherlands
 
You can use the Table Formatting options of the Tables to do this without using Conditional Formatting.

It can apply zebra stripes to the filtered data within a table.
 
30-12-2010

Although a table format is working nice it must be possible to choose only <visible lines> by selecting properties or something like that. Disadvantage of the table formatting is that it means a fixed number of lines and that is what I do not like. When I filter say, 1000 lines to display 25 (and calculate on some rows) I still want the up/down coloring.

Anuone?

Bob Hilderink, NL, Hilcom
 
Hilcom

When using Excel Tables I am referring to Selecting an area and converting it to a table using Insert Table.

Once done and filters applied the rows maintain there zebra stripes after filtering.

If you add additional rows/columns they also take on the same formatting and applied filters provided they are directly adjacent (without any spaces) to the table.


Table formatting isn't limited to fixed number of lines ?


Can you be more specific about what your doing, what version of Excel etc ?
 
Back
Top