| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to pop up a message based on a cell value??
Hello,
My Cell C3 is a numeric value.....I have set conditional formatting to make the text red and bold when the number is equal or less than 10,000 is there a way I can make cell E3 display a message when the C3 condition is true?? or if not a message is there a way to make a message box pop up when my C3 condition of less then or equal to 10,000 is true? how would I do something like this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to pop up a message based on a cell value??
Hi!
make cell E3 display a message when the C3 condition is true?? Enter this formula in cell E3: =IF(AND(ISNUMBER(C3),C3<=10000),"Your message here","") Biff "paul" wrote in message oups.com... Hello, My Cell C3 is a numeric value.....I have set conditional formatting to make the text red and bold when the number is equal or less than 10,000 is there a way I can make cell E3 display a message when the C3 condition is true?? or if not a message is there a way to make a message box pop up when my C3 condition of less then or equal to 10,000 is true? how would I do something like this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to pop up a message based on a cell value??
Again thank you!
Biff wrote: Hi! make cell E3 display a message when the C3 condition is true?? Enter this formula in cell E3: =IF(AND(ISNUMBER(C3),C3<=10000),"Your message here","") Biff |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to pop up a message based on a cell value??
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to pop up a message based on a cell value??
You're welcome!
Biff "paul" wrote in message ups.com... Again thank you! Biff wrote: Hi! make cell E3 display a message when the C3 condition is true?? Enter this formula in cell E3: =IF(AND(ISNUMBER(C3),C3<=10000),"Your message here","") Biff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
| How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
