CODEWITHSUNDEEP
google-sheetsconditional-formatting
user23276790
user23276790

Reputation:

Conditional formatting does not respect the range of application - Google Sheets

The range of application of conditional formatting with custom formula is set for the whole row, but only the first column is highlighted. For some reason, when adding more columns to the spreadsheet, the conditional formatting works normally. What causes this?

The conditional formatting formula returns positive if there are duplicate rows: =COUNTIFS($B$1:B;$B1;$C$1:C;$C1;$D$1:D;$D1;$E$1:E;$E1;$F$1:F;$F1;$G$1:G;$G1)>1

No new columns added

5 columns added to the right and same "Apply to range"

I added new columns and it started working normally, but I don’t want these extra columns. Is there another solution?

Upvotes: 0

Views: 62

Answers (1)

z..
z..

Reputation: 13013

Try locking all the columns:

=COUNTIFS($B$1:$B;$B1;$C$1:$C;$C1;$D$1:$D;$D1;$E$1:$E;$E1;$F$1:$F;$F1;$G$1:$G;$G1)>1

Upvotes: 0

Related Questions