I don't think DV works in this scenario.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Claudio Silva" wrote in message
ps.com...
Dear Andy,

In fact, i´m traying to use it..
But, without success..

I dont know exactly how to use this function with formulas
=(


Andy Morton wrote:
I look for solutions that avoid VB.
Have you tried Excel's built-in Data validation ?
Its's in the Data menu.
Not difficult to understand.
It checks data entered in a cell to see if it's conforms to your criteria.
Not sure that it will work for what you need.

Andy