Alerts user of incorrect data input.
Soft validation
In the example below, cascading Excel formulas build logic alerting the user that forecast revenue is lower than 80% of the previous year.
The Enable soft validation option is set to on. The Validation check is set to $M$7, and the Validation message is set to $N$7 on the Writeback tab of the Workbook Options window.
When the user attempts to save the report, a message appears stating: 2 cells contain values lower than 80% of last year. Are you sure you want to save this?
