Mandatory cells in excel using OR condition

[ykksap]

Hi All,

Please help me on below requirement in excel.


If i maintain any value on NAME cell any one of (Father name (or) mother name (or) guardian name cell value should be mandatory.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Father name[/TD]
[TD]Mother name[/TD]
[TD]guardian name[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD][/TD]
[TD]XXXX[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sunny[/TD]
[TD][/TD]
[TD][/TD]
[TD]XXXX[/TD]
[/TR]
</tbody>[/TABLE]


Many Thanks
Kishore kumar

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1030204-mandatory-row-values-out-any-three-rows.html

You already asked this question last week and got a reply that you never responded to.

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).