Home

Obligation of data entry order using data validation

%3CLINGO-SUB%20id%3D%22lingo-sub-369410%22%20slang%3D%22en-US%22%3EObligation%20of%20data%20entry%20order%20using%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369410%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20sheet%20for%20my%20colleague%20to%20work%20on.%3C%2FP%3E%3CP%3EI%20set%20some%20custom%20data%20validation%20rules%20combination%20using%20AND%20function%2C%20and%20I%20need%20to%20add%20to%20these%20rules%20that%20the%20cell%20should%20not%20accept%20any%20entry%20unless%20another%20specific%20cell%20is%20filled%20first.%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3EI%20need%20to%20restrict%20the%20entry%20in%20cell%20C3%20using%20some%20sort%20of%20values%20and%20rules%20using%20custom%20AND%20function.%3C%2FP%3E%3CP%3ENow%20I%20need%20to%20add%20a%20restriction%20that%20cell%20F3%20should%20not%20be%20empty%2C%20means%20that%20F3%20should%20be%20filled%20first%20(F3%20actually%20contains%20a%20data%20validation%20drop%20down%20list.%3C%2FP%3E%3CP%3EHow%20to%20add%20this%20part%20to%20the%20AND%20formula%20in%20data%20validation%3F%3C%2FP%3E%3CP%3EPS%3A%20I%20tried%20adding%20And(F3%26lt%3B%26gt%3B%22%22%3C%2FP%3E%3CP%3Eand%20it%20did%20not%20work%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369644%22%20slang%3D%22en-US%22%3ERe%3A%20Obligation%20of%20data%20entry%20order%20using%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369644%22%20slang%3D%22en-US%22%3EIf%2C%20for%20example%2C%20you%20want%20a%20value%20more%20than%200%20in%20C3%2C%20if%20F3%20is%20not%20blank%2C%20the%20your%20custom%20formula%20for%20data%20validation%20in%20C3%20is%3A%3CBR%20%2F%3E%3DIF(NOT(ISBLANK(F3))%2CC3%26gt%3B0%2C%E2%80%9D%E2%80%9D)%3C%2FLINGO-BODY%3E
Ayman Hassan
Contributor

Hello,

I need to create a sheet for my colleague to work on.

I set some custom data validation rules combination using AND function, and I need to add to these rules that the cell should not accept any entry unless another specific cell is filled first.

For example:

I need to restrict the entry in cell C3 using some sort of values and rules using custom AND function.

Now I need to add a restriction that cell F3 should not be empty, means that F3 should be filled first (F3 actually contains a data validation drop down list.

How to add this part to the AND formula in data validation?

PS: I tried adding And(F3<>""

and it did not work fine.

 

1 Reply
If, for example, you want a value more than 0 in C3, if F3 is not blank, the your custom formula for data validation in C3 is:
=IF(NOT(ISBLANK(F3)),C3>0,””)
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies