I have applied data validation to allow whole numbers between 1 and 3 in a column of data. The kicker is that the result in those cells is calculated using a formula. It looks as though data validation only works using data input into a cell. I'm not sure why this limitation is in place but I'm sure that microsoft has their reasons.
Is there a simple way that I can implement data validation to a range of cells that the result is calculated using a formula?
Thanks
Windows XP
Excel 2007
Is there a simple way that I can implement data validation to a range of cells that the result is calculated using a formula?
Thanks
Windows XP
Excel 2007