Multiple Data Validation in one cell

[TheScreenKing]

I am trying to get 2 data validations in one cell I am using the formula
=AND(COUNTA($E3:$P3)<=1,C2>0,D2>0)
I am needing there to be only 1 item between e3-p3
But C2 and D2 must be filled out before any info is entered into e3-p3

Please help?

 

[MarcelBeug]

Try this formula, applicable for E3:P3

=COUNTA($E3:$P3)<=--AND($C2<>"",$D2<>"")

 

[TheScreenKing]

I am not having any luck I have been stuck on this for a while

 

[TheScreenKing]

It didn't work

 

[Peter_SSs]

What is in C2 and D2? Formulas or constants? Numbers or text?

 

[TheScreenKing]

Thank you for your interest to help Peter
This is What it looks like

<colgroup><col style="mso-width-source:userset;mso-width-alt:3421;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:5026;width:108pt" width="144"> <col style="mso-width-source:userset;mso-width-alt:1512;width:33pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:1349; width:29pt" span="11" width="39"> </colgroup><tbody>
[TD="class: xl66, width: 98"]Screen Type[/TD]
[TD="class: xl66, width: 144"]Panel[/TD]
[TD="class: xl66, width: 43"]10' 120"
[/TD]
[TD="class: xl66, width: 39"]9' 108"[/TD]
[TD="class: xl66, width: 39"]8'6" 102"[/TD]
[TD="class: xl66, width: 39"]8' 96"[/TD]
[TD="class: xl66, width: 39"]7'6" 90"[/TD]
[TD="class: xl66, width: 39"]7' 84"[/TD]
[TD="class: xl66, width: 39"]6'6" 78"[/TD]
[TD="class: xl66, width: 39"]6' 72"[/TD]
[TD="class: xl66, width: 39"]5'6" 66"[/TD]
[TD="class: xl66, width: 39"]5' 60"[/TD]
[TD="class: xl66, width: 39"]4' 48"[/TD]
[TD="class: xl66, width: 39"]3' 36"[/TD]

[TD="class: xl67"]18/14
[/TD]
[TD="class: xl67"]Roof[/TD]
[TD="class: xl68, align: right"]20
[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl69"] [/TD]
[TD="class: xl69"]Sm Roof[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"]
[/TD]
[TD="class: xl70, align: right"]30[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl69"] I dont know if this helps you?
[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]

</tbody>

 

[TheScreenKing]

The top row is The header In this picture I want there to be only 1 value in $C3:$N3
And No information able to be entered in $C3:$N3 until information is entered in both $B2 and $C2

 

[MarcelBeug]

I made a screen recording and sent the link in a private message.

 

[TheScreenKing]

HAHAHA silly me!!! I had the ignore blank cells checked Thank you so Much Marcel!!!

 

[MarcelBeug]

You're welcome.