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
|