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?

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?

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

how to pop up a message based on a cell value??
 

hey its not me!
--
paul

remove nospam for email addy!



"paul" wrote:

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

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