Conditional formatting with a prompt and new email message

[Tammy]

Hi - two parts to my question:

1. Conditional formatting has been added to cells in a spreadsheet (if a
value is 0-1, format one way; if = 2 format another way; if greater than or
equal to the number 3 format a third way) - works great. When the value of a
cell is greater than or equal to the number 3, my user would also like a
prompt indicating that the cell contains a number greater than or equal to
the number 3. Is there a way to do this "out of the box"? My user and I are
not programmers, so wouldn't be able to trouble shoot code, if necessary. The
cells that contain the conditional formatting are never touched. There is a
formula attached to those cells that sums a row of numbers.
2. The other thing he would like, or in place of the first request, is to
have a new email message created automatically, based on whether the cell
contains a value greater than or equal to the number 3. He has a column with
email addresses in it, and would like to know if it's possible to have Excel
automatically create a new email message using the email address from the
same row as the cell that contains the >=3 conditional format. I haven't
found anywhere to do this out of the box, so suspect programming would be
needed, but thought I'd ask.

Please let me know if you need any more details. Thanks for any suggestions!

 

[Jim Thomlinson]

The e-mail would require code and I assume that you are't looking in that
direction.

The first is relativelyl easy by adding data validation to the cells in
question.

Data -> Validation...
Allow Whole Numbers between 1 and 3 or...
On the error alert tab change from Stop to Warning and add an appropriate
message...

 

[Tammy]

Thanks so much for your response, Jim. Re: data validation, I thought of
that, but the user would have to be entering data into a cell that contains
the validation rule. My user will never touch the cell that I am referring
to. There is a formula in that cell that is linked to a row of cells - when
the formula updates, that's when the conditional formatting kicks in for that
cell. When the cell that contains the conditional formatting reaches a
specific number is when I'd like the prompt to appear. Unless I'm missing
something with data validation, I don't believe prompts would appear unless
the user was actually typing in a cell where the data validation rule
exists?...

Thanks again, Jim!