I want to write a custom data validation formula which checks the value of three cells.
For instance -
The formal applies to cell A1 only. The validation is to make sure Cells A1, and A2 and A3 are all greater than zero (ignore blanks in these cells.)
Generally - only allow data entry if A1 A2 A3 are greater than 0 and if not STOP and display message data entry values need to be greater than zero, no negative entries allowed.
Regards,
-j
Bookmarks