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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting with a prompt and new email message
Thanks so much for your response, Jim. 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! :) "Jim Thomlinson" wrote: 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... -- HTH... Jim Thomlinson "Tammy" wrote: 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! |
Reply |
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 |