mandatory row values out of any three rows

[ykksap]

Hi Gurus,

Emp name	father name	mother name	Guardian name
James	XXX	XXX	XXX
david		XXX

<tbody>
</tbody>

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

			<colgroup><col><col><col><col></colgroup><tbody></tbody>

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[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)