Re: How to red flag certian numbers when entered to a spredsheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

To highlight duplicate numbers see Chip Pearson's site for using CF.

http://www.cpearson.com/excel/Duplicates.aspx

To prevent duplicate numbers in the first place using Data Validation see Chip's
site at

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


Gord

On Sun, 16 Sep 2007 14:58:01 -0700, Bill <Bill@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I want to add nine numbers like a social security number and if it's
duplicated it will red flag is this possable

"Gord Dibben" wrote:

How many "certain numbers" are you looking at?

Conditional formatting will give you 3 conditions(4 if you count default)

Excel 2007 allows more than that.

For up to 30 conditions in versions 97 through 2003 you can use Bob Phillips'
CFPlus add-in.

http://www.xldynamic.com/source/xld.CFPlus.Download.html


Gord Dibben MS Excel MVP

On Sun, 16 Sep 2007 14:22:01 -0700, Bill <Bill @discussions.microsoft.com>
wrote:

Is there a formula that can be made so when you enter a bank numbers in to a
column it will red flag those certian numbers on the spred*** column ie if
i entered 123 in a cell it would be formatted to come up red?



.

Quantcast