Data validation only imposes constraints on what the user can type
into a cell. It has nothing to do with calculated values. The closest
you can get is to use Conditional Formatting to change the color of a
cell based on some criteria.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 10 Nov 2008 10:17:01 -0800, jpzachar
wrote:

Hello......I hope you can help....thanks in advance!

I would like to have an error message pop up if the result of a formula in
cell N100 is greater than 5. I tried using the data validation and "custom"
selection but could not get it to work. Is this possible?

thanks,
Jeff