Only Allow Writing Numbers in One of the Two Columns

Excel file teaching how to perform Only Allow Writing Numbers in One of the Two Columns operation.

Excel Source: Only Allow Writing Numbers in One of the Two Columns

Data validation conditions are defined by formula. The user is warned in case of incorrect entry. Cell validation is performed in real time. Blank cells are allowed. The rule applies to all rows.

Hope it is useful.