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 spredsheet column ie if
i entered 123 in a cell it would be formatted to come up red?

Look up "Conditional Formatting" in the help files.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill" <Bill @discussions.microsoft.com wrote in message
...
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 spredsheet column ie
if
i entered 123 in a cell it would be formatted to come up red?

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.....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 spredsheet column ie if
i entered 123 in a cell it would be formatted to come up red?

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.....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 spredsheet column ie if
i entered 123 in a cell it would be formatted to come up red?

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 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.....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 spredsheet column ie if
i entered 123 in a cell it would be formatted to come up red?