• In cell A1 I have the text "hello".
  • In cell A2 the text "hello" appears again.
  • In cell A3 I have the text "goodbye".
  • In cells A4:A10 the text "goodbye" appears again.

Is there are a way (with conditional formatting and formulas probably) to find every time the words "hello" and "goodbye" appear for the second or third or fourth (etc.) time and color those cells in a certain way? In the example above I would want A2, and A4:A10 to be colored.

Ideally I wouldn't have to add a conditional format rule for "hello" and "goodbye", but could instead have one rule which finds any time a word is repeated.

1 Answer 1


Please use the following rule


Highlight duplicates except first one

(adjust range to your needs)


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.