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
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