Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt to Save Message | Excel Discussion (Misc queries) | |||
Email From a date prompt | Excel Discussion (Misc queries) | |||
Conditional formatting - copy & paste to an email | Excel Discussion (Misc queries) | |||
conditional formatting error message | Excel Worksheet Functions | |||
help with message prompt | New Users to Excel |