View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Way to create a note based on the contents entered in a cell?

You could use data validation.
Choose decimal less than 150.
In the error alert switch to Information from Stop add in a title and a
message.

If less than 150 nothing happens. If 150 or greater then the information box
shows up with your message.
--
HTH...

Jim Thomlinson


"Nicci" wrote:

I know you can conditionally format a cell to show a different color when a
certain number is entered but is there a way to have a congratulatory note
pop up upon entry. I want to have a comment box, a note, a textbox, or
anything similar pop up on the screen if someone enters a number greater than
150 in a certain cell. Other than having something show up in a separate
cell on the worksheet, is there any way to do this that I haven't thought of?
I'm not good with Macros... thanks