C
C
CREWbig2020-02-17 18:58:11
Google Sheets
CREWbig, 2020-02-17 18:58:11

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

Hello, back to the table gurus for help.
How to set conditional formatting for a column with line spacing.
For example, it is necessary that when the conditions are met, lines 1-3-5-7 .. and so on are half-lit, although the conditions can be met in the same way in other lines

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-02-18
@oshliaer

Probably the easiest way is to exclude each line when checking the condition, for example,
=AND($E1="Female";ISODD(ROW($E1)))
this means: "for each Ethat is equal Femaleand the line is odd.
5e4b6b7d5f930045245826.png
Another option is to use alternative colors, but they do not check the conditions in any way, just for beauty.
5e4b6b9817271256662228.png
Example

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question