how do i add an error message if someone enters wrong data
 

Im looking at setting up a worksheet and want some error messages to appear
if operators but incorrect information. Please help?!

Mike

how do i add an error message if someone enters wrong data
 

On your menu bar you will find

Data - Validation

This allows you to validate the data enetered in a cell and dispay an error
/ alert message if it does not meet certain standards.
--
HTH...

Jim Thomlinson


"Mike" wrote:

Im looking at setting up a worksheet and want some error messages to appear
if operators but incorrect information. Please help?!

Mike

how do i add an error message if someone enters wrong data
 

Thanks Jim,

Done that but one problem.... I want the error message to come up if it does
not = 100. This is generated from two other cells (a formula). ie 30 + 60
do not = 100 so i want the error to come up then. How can i make this work?
I know i could just higlight the cell in conditional formatting but i need it
to be more obvious

Thanks

"Jim Thomlinson" wrote:

On your menu bar you will find

Data - Validation

This allows you to validate the data enetered in a cell and dispay an error
/ alert message if it does not meet certain standards.
--
HTH...

Jim Thomlinson


"Mike" wrote:

Im looking at setting up a worksheet and want some error messages to appear
if operators but incorrect information. Please help?!

Mike

how do i add an error message if someone enters wrong data
 

Use Custom data validation... This checks Cells B2:C2 to ensure that they
equal 100

=NOT(AND(COUNT($B2:$C2)1, SUM($B2:$C2)<100))

The count is there to only validate if both cells are filled in.
--
HTH...

Jim Thomlinson


"Mike" wrote:

Thanks Jim,

Done that but one problem.... I want the error message to come up if it does
not = 100. This is generated from two other cells (a formula). ie 30 + 60
do not = 100 so i want the error to come up then. How can i make this work?
I know i could just higlight the cell in conditional formatting but i need it
to be more obvious

Thanks

"Jim Thomlinson" wrote:

On your menu bar you will find

Data - Validation

This allows you to validate the data enetered in a cell and dispay an error
/ alert message if it does not meet certain standards.
--
HTH...

Jim Thomlinson


"Mike" wrote:

Im looking at setting up a worksheet and want some error messages to appear
if operators but incorrect information. Please help?!

Mike