How To Make The Data Range Look Like Tables?

I want to make the data range look like tables.


One row is filled with darker color the other one is filled with brighter color.


In Home - Styles there are only bicolor fills. Do I have to fill the rows one by one?


How to do that easily?

Hi zanshin777 ,

First create the table and then convert it to the range and from there you can use formate painter.

Punnam

I would use conditional formatting.

Highlight the range in one colour, then enter the conditional format formula =MOD(ROW(),2) and select a contrast colour.

I have attached an example.

Thank you very much all for the answers.

Both methods and both formulas in conditional formatting work.

You're welcome @zaqnshin77, and thanks for the Rep.

An extra tip for you in case you want to FILTER the data. You will need a different formula.

Assuming your data is in A1, with headings(and filters) on the first row.

=MOD(SUBTOTAL(3,$A$1:$A1),2)

Note: You need to ensure that there are NO BLANK CELLS in the first column because the SUBTOTAL() part of the formula is counting cells with data.

Regards,

David