View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
paul paul is offline
external usenet poster
 
Posts: 11
Default 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