Software

Ask something
Discussion Locked

Excel Data Validation

0 helpful
5 replies

by kfultz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Using 'Input Message' under Data Validation, but not validating anything. The box shows up when you click on the cell, but the box is solid black and the text is not there. Any suggestions?

5 replies

by richtee

One possible item to check:

On the Input Message tab: Confirm that the box "Show input message when cell is selected" is checked.

Hope it is this simple. Rich

by kfultz

Yes, I have ensured that box is checked. I have tried but been unsuccessful in finding a way to format the box to see if that is the reason. Even checked with IT and they are just as confused as I am about it. Thanks, though, for the suggestion.

by neil m

Not normal behaviour and I don't have any real answers but check the following:
1) when you insert a comment is the background black?
2) if you display the office assistant does it display the message?

by kfultz

Yes, I inserted a comment and the background was black. I changed the formatting on that just to see if it had any impact on the data validation message, and it did not. But, when I displayed the office assistant and then clicked on that cell,my message appeared as a bubble from it. If anyone has more info on this, it would be greatly appreciated!!

This discussion is closed to new replies.