How to set the range in the conditional formatting through the line?

Welcome again to the guru of the tables for help.
How to set conditional formatting for a column with an interval in a line.
For example, it is necessary that when performing terms - polticians line 1-3-5-7.. and so on, although the conditions can be executed also in other rows
April 7th 20 at 15:32
1 answer
April 7th 20 at 15:34
Probably the easiest way is to delete every row in the test statement, e.g.

=AND($E1="Female";ISODD(ROW($E1)))

means: "for each Ethat is equal to Female and the string is odd.

5e4b6b7d5f930045245826.png

And another option is to use alternative colors, but they are not checking the conditions, just for beauty.

5e4b6b9817271256662228.png

Example

Sincerely,
contributor.pw

To invite a guru on this forum there is a button to "invite an expert".

Find more questions by tags Google Sheets