View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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