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

P

paul

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?
 
B

Biff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top