mandatory row values out of any three rows

[ykksap]

Hi Gurus,

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Emp name[/TD]
[TD]father name[/TD]
[TD]mother name[/TD]
[TD]Guardian name[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]XXX[/TD]
[TD]XXX[/TD]
[TD]XXX[/TD]
[/TR]
[TR]
[TD]david[/TD]
[TD][/TD]
[TD]XXX[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i have a requirement in excel, i want to save an employee details name as Jmaes i need any one of father/mother/guardian columns row value should be mandatory for this requirement please help me with your solution like validation or macro.

if i miss provide the james father/mother/guardian details it should provide the error message like please provide james father/mother/guardian details.

Please help me on this

[TABLE="width: 563"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 563"]
<colgroup><col><col><col><col></colgroup><tbody></tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

The error message is difficult because when does it trigger? You would usually fill in one cell before the other. Id use conditional formatting i think to colour the cells should the condition not be met. Such as:

=AND(LEN($A1)>0,COUNTA($B1:$D1)=0)