Excel Question

  dazwm 14:57 14 Dec 06
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 06

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 06

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

  VoG II 15:34 14 Dec 06

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.

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5