Validation

[dfenton21]

Hi All,

Is there anyway to use data validation on cells that contain formula (even through VB).

I have two cells - if the second cell is greater than 0, the first cell should not be less than 14. These two cells contain count formulas. I still want the user to be able to change it, but I would like a message displayed.

Can that be done.

Thanks

 

[jbeaucaire]

"Message to be displayed" is a little vague. If the values are changing via formula, then they're changing on their own, yes? In that case the quickest "message" would be in the formula itself.

You could make your formula smart enough to check it's own value, and if it doesn't meet some criteria, display a message instead.

=IF(A1+B1>C1,"Too high",A1+B1)

Also, or instead of, you could use Conditional Formatting to cause the cells to change color to draw attention to themselves when the values are undesirable.

Beyond this, of course, is a multitude of macros and worksheet event code that could do stuff, but that may be more plumbing than you're interested in maintaining.