LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prompt to Save Message Adam O Excel Discussion (Misc queries) 2 December 10th 08 08:22 PM
Email From a date prompt stew Excel Discussion (Misc queries) 1 September 21st 08 05:06 PM
Conditional formatting - copy & paste to an email Gapps Excel Discussion (Misc queries) 0 July 17th 07 05:56 AM
conditional formatting error message Karla V Excel Worksheet Functions 3 October 31st 06 03:37 AM
help with message prompt Monty New Users to Excel 1 September 9th 05 10:03 AM


All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"