Setting up an error alert in excel

[Kathleen]

Hi,

I have an excel form with many fields impacting a formula when populated.
In box one is a comment and box two is a score. I want to make sure the user
who has entered into box one the comment, also entes a score in box two. If
the user doesn't populate both fields, is there a way to let the user know
there is a possible error?

Kathleen

 

[Bob Greenblatt]

Hi,

I have an excel form with many fields impacting a formula when populated.
In box one is a comment and box two is a score. I want to make sure the user
who has entered into box one the comment, also entes a score in box two. If
the user doesn't populate both fields, is there a way to let the user know
there is a possible error?

Kathleen

Sure, there are a bunch of ways. Here's one: set up another warning cell
with a formula that looks something like:
=if(len(commentcell)*len(scorecell)>1,"","Enter stuff in both cells")

You can then apply a conditional format to change the cell background to red
or some other appropriate highlight when the error occurs.

 

[Kathleen]

THANK YOU!

Sure, there are a bunch of ways. Here's one: set up another warning cell
with a formula that looks something like:
=if(len(commentcell)*len(scorecell)>1,"","Enter stuff in both cells")

You can then apply a conditional format to change the cell background to red
or some other appropriate highlight when the error occurs.