How to apply alternate row background colors? And how to apply this in tables that already have conditional formatting?

edit

Hello

Q1 How to apply alternating rows?

• Define 2 cell styles with your desired background (e.g. BGGrey and BGWhite)
• Format -> Conditional -> Condition...
• Condition 1: Formula is ISEVEN(ROW()) Apply Style: BGGrey
• Condition 2: Formula is ISODD(ROW()) Apply Style: `BGWhite?
• Range: A2:AMJ1048576 (assuming row 1 contains a header)

In case you what that ro apply for columns just replace function ROW() by COLUMN().

Please note This reduces direct formatting options of cells (e.g. in this case you can't change the background color any longer, since conditional formatting takes precedence).

Q2 Add alternating rows colorization to existing conditional formatting possible?

Yes - but this requires additional effort, since you would need to exclude the ranges of existing conditional formatting from the ranges above in Q1 and add the Q1 rules after the existing conditional formatting to assure precedence of rules.