highlighting cells if value is repeated
 

Hi

I have a column named item number, the user enters a number into thes
cells, I would like a cell to be highlighted red if the same number i
used again as well as the orignal cell. What feature would I use to d
this?

Thanks for any help

--
Skill
-----------------------------------------------------------------------
Skills's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26593

highlighting cells if value is repeated
 

conditional formatting, with a formula of

=COUNTIF($A$1:$A$100,A1)1

--

HTH

RP

"Skills" wrote in message
...

Hi

I have a column named item number, the user enters a number into these
cells, I would like a cell to be highlighted red if the same number is
used again as well as the orignal cell. What feature would I use to do
this?

Thanks for any help.


--
Skills
------------------------------------------------------------------------
Skills's Profile:
http://www.excelforum.com/member.php...o&userid=14946
View this thread: http://www.excelforum.com/showthread...hreadid=265935

highlighting cells if value is repeated
 

use conditional formatting for this

You would use the countif worksheet function to determine if there are
duplicates.

--
Regards,
Tom Ogilvy


"Skills" wrote in message
...

Hi

I have a column named item number, the user enters a number into these
cells, I would like a cell to be highlighted red if the same number is
used again as well as the orignal cell. What feature would I use to do
this?

Thanks for any help.


--
Skills
------------------------------------------------------------------------
Skills's Profile:
http://www.excelforum.com/member.php...o&userid=14946
View this thread: http://www.excelforum.com/showthread...hreadid=265935

highlighting cells if value is repeated
 

Assume your values are all in Col A, select Col A, do Format / Conditional
Formatting / Change 'Cell value' is to 'Formula is' and put in
=AND(A1<"",COUNTIF($A:$A,A1)1) and then hit the format button and choose a red
pattern from the pattern tab.

If data was across Columns A:C then select columns A:C and change formula to:-

=AND(A1<"",COUNTIF($A:$C,A1)1)

If only using a small range then select only that range and ensure that the top
left cell in your range when selected is what goes into the formula where A1
currently is, and the whole range replaces the $A:$C bit.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Skills" wrote in message
...

Hi

I have a column named item number, the user enters a number into these
cells, I would like a cell to be highlighted red if the same number is
used again as well as the orignal cell. What feature would I use to do
this?

Thanks for any help.


--
Skills
------------------------------------------------------------------------
Skills's Profile:
http://www.excelforum.com/member.php...o&userid=14946
View this thread: http://www.excelforum.com/showthread...hreadid=265935



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 29/09/2004

highlighting cells if value is repeated
 

Skills

See Chip Perason's "Highlighting Duplicates" info.

http://www.cpearson.com/excel/duplic...tingDuplicates

See also his "Preventing Duplicates" if that is your goal.

http://www.cpearson.com/excel/NoDupEntry.htm

Gord Dibben Excel MVP

On Sun, 3 Oct 2004 17:28:06 -0500, Skills
wrote:


Hi

I have a column named item number, the user enters a number into these
cells, I would like a cell to be highlighted red if the same number is
used again as well as the orignal cell. What feature would I use to do
this?

Thanks for any help.