validation of mutually exclusive cells in Excel 2007/2010
Posted on 2012-03-28
I have a group of adjacent cells (e.g., A2, B2, C2, D2 on the same row) in Excel 2007/2010. Only one should be filled. Is there a way to give a visual cue to the user indicating that the input is invalid until at least one cell in the set is filled out. (There can be other sets of related/mutually exlusive fields on the same row.)
A visual cue could mean some kind of conditional formatting where the 4 cells are highlighted in red until at least one cell in the set is filled. Then all 4 cells turn green.
If 2+ cells are filled out, then the 4 cells are highlighted in red again. (Or instead of a color, it could be an error message that appears in A1 for example.)
I'd appreciate a sample spreadsheet to understand how this could be done, if at all possible?
Thanks and best regards, Lyteck