|Let's see if I can get it right this time...|
If only one of the cells contains data then the others could be blank. Is that good or bad? GOOD Thats what I want and need. At least ONE must have data.
To more specific, what I really need is for the End user to add data to cells B2,C2,D2 (at least one or all) but if the User completes E2 then there would be no need to have data in B2:D2. These cells are meant to track Error classification (if any error at all). The User inputs the error severitiy (as follows)
Major Minor Admin No Error
I think the following will help you better understand my issue/need:
A B C D E
1 Cust Error Severity Err. Sev. Err. Sev. No Error
2 ABC Jeans Major Minor Admin Blank
3 Lemon Slice No Error
I hope this makes more sense?
message edited by HarrisLyfe2016