Excel Question

  dazwm 14:57 14 Dec 2006
Locked

I have a list of numbers in column A. How do I highlight each cell when the number shows up more than once (conditional formatting I think). For example if the number 123 appears more than once I want those cells to turn red. Thanks.

  VoG II 15:20 14 Dec 2006

In A1 use the Conditional Format 'Formula Is':

=COUNTIF(A:A,A1)>1

and apply your formatting. Then in A1 click the Format Painter button ('paint brush') then select all relevant cells in Column A to copy the format.

  dazwm 15:33 14 Dec 2006

That doesn't seem to be working or maybe its a bit complicated for me!!

  VoG II 15:34 14 Dec 2006

If you want an example workbook, click my yellow envelope to e-mail me.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?