Setting limits for cell value

This is a discussion on Setting limits for cell value within the Excel Questions forums, part of the Question Forums category; I would like to set a limit for the maximum value of a cell, and if possible have an error ...

I would like to set a limit for the maximum value of a cell, and if possible have an error message such as are you sure, or some other visual notification that the cell value is outside set parameters... for example... if cell value is greater than 250.