I made the formatting so it will flag as red when it detects duplication. My table has 3 column (A,B,C and titled as Id , brand, type respectively). I want to detect if there's duplicate in 'brand' column. It will be colored in red if there's duplication.

I made a formula (as in the attachment) and it works fine, but I want the red color for all the column not only 1 cell (in this case I want all the column A,B,C to be red). If I try changing the 'apply to range' to A2:C1000 , logically this should make col A,B,C to be red. But the result , only col A is red now.

Does anyone know how to fix it?

See below table and the formula:

enter image description here

enter image description here

1 Answer 1


Use =countif($B2:$B, $B2) > 1. See absolute and relative references.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.