CODEWITHSUNDEEP
google-sheets
Karric
Karric

Reputation: 1565

Google Sheets - Conditional Formatting is overriding background color

I have a conditional format to color the background of even rows. I have another conditional format that changes the color of the text for duplicate cells, but this is removing the background color of even rows. If I switch the hierarchy of these formats, then I lose the text colouring but get back the coloured rows.

Not sure how to fix this.

Upvotes: 11

Views: 6982

Answers (1)

Max Makhrov
Max Makhrov

Reputation: 18717

There's no direct way to do this in Google Sheets. But, there's good workaround.

Make the third Conditional formatting rule with your formula, checking both conditions:

=and(iseven(row($A1)),countif($A1:$A,$A1)>1)

and set it's hierarchy to the top.

Upvotes: 13

Related Questions