I have an assignment wherein i want to enforce a condition on few cells, not to leave it blank if one particular cell in the same row contains some value. How can i put this check? I'm relatively new to Excel stuff. So, please assist me in this case.
If I enter a vaue in Column A1, then i should auotmatically enforce a condition on cells A2-A10 that it should not left blank.