Hello,
I would like to alternate the raw colors of a calc spreadsheet even if the table is filtered.
for example one red line, one white line.
In “conditional formating” the formula : =MOD(LIGNE();2)=0 doesn’t work well when the table is filtered because this is testing if the raw is even or not. Consequently I will get for example two red lines, 5 white line, … I would like the red/white color to alternate even if the table is filtered.
Does anyone have a solution for this case ?
Thank you.