Forum Discussion
Solved
Data Validation Error Alerts for Cells with Formulas
I'm adding an Error Alert to a spreadsheet through Data Validation. I should receive an error message whenever: BP3*1>$BP$4*1 If I manually enter a number into cell BP3 that is greater than ...
Hi warrevar
no, data validation rules apply only for manual entries, not for formulas.
You could instead use conditional formatting, for example to highlight the cell if the calculated value breaks the rule. Example:
Or you could enter a message in a cell beside BP3, that only appears if the rules apply:
=IF(BP3>BP4,"Warning: Value is to high!","")
Kind regards,
Martin
Hi warrevar
no, data validation rules apply only for manual entries, not for formulas.
You could instead use conditional formatting, for example to highlight the cell if the calculated value breaks the rule. Example:
Or you could enter a message in a cell beside BP3, that only appears if the rules apply:
=IF(BP3>BP4,"Warning: Value is to high!","")
Kind regards,
Martin
