Answer the question
In order to leave comments, you need to log in
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
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 E
that is equal Female
and the line is odd.
Another option is to use alternative colors, but they do not check the conditions in any way, just for beauty.
Example
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question