View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steen Steen is offline
external usenet poster
 
Posts: 104
Default Conditional Formating - Different row color also when using filter

Hi

Can anyone give a hint on how to make each 2'nd line colored - also when
using filtering. I am currently using conditional format formular:
mod(row();2)=0, but when using filter it happens that nestet rows has all odd
or even numbers, resulting in the same color.

Any suggestions to solve this issue?

/Steen