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?