View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tammy Tammy is offline
external usenet poster
 
Posts: 145
Default Conditional formatting with a prompt and new email message

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!