AutoFill Aternate ROW's with grey except some Column or cell

[brainzlp]

How can i condicional format alternating row YES row NO, the color of the fill.

I need the first visible row to be White, then alternate grey.

I have manage to do grey white grey although need it to be white grey white.
I used this PT code:

Please Login or Register  to view this content.

in conditional formatting.

[ChemistB]

Can you upload an example spreadsheet (Go Advanced>Manage Attachments) I don't even know what RESTO stands for in English and not sure how your data is using Subtotal.

[reagan.kha]

This is the conditional formatting formula you want.

=NOT(MOD(ROW(),2)=0)

[brainzlp]

This is the conditional formatting formula you want.

=NOT(MOD(ROW(),2)=0)

Formula doesn't work properly.

When i filter, the Grey is the first. I want the white first then grey

Can you help ?

[brainzlp]

This is the conditional formatting formula you want.

=NOT(MOD(ROW(),2)=0)

I want that the
1st VISIBLE ROW is WHITE
2nd VISIBLE ROW is GREY
3rd VISIBLE ROW is WHITE
Etc etc

[brainzlp]

SOLVED alone

Solution:

Please Login or Register  to view this content.