Hello everyone,
I have a question. I am currently working with a very long List of items. To
make the list more reading-friendly, I would like to have a horizontal border
line every 5 rows, or every 5th row to have that row with a different color
fill for example.

On my first column I have the number of item. One way in which I thought it
could work was to use the ISEVEN combined with RIGHT to have Excel check the
last number of the item number and apply a Conditional Formatting if cell
value is 0 or 5. I don't know what is going on but for some strange reason it
doesn't even recognize the simple ISEVEN function...

Anyways the problem I was going to have later on is that when I would apply
a Filter to the List the those horizontal lines would be all mixed up. Is
there any way to apply something like a Format but to the Background? Not as
a image but more like something that no matter what every "n" rows I will
have a border line?

,thanks
Ed