Data in cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2429978%22%20slang%3D%22en-US%22%3EData%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2429978%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20to%20cells%20in%20the%20same%20row%20A10%20and%20B10%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20there%20is%20entered%20data%20in%20A10%20there%20should%20not%20to%20be%20allowed%20to%20enter%20data%20in%20B10%20and%20vice%20versa.%3C%2FP%3E%3CP%3EIt%20should%20only%20allowed%20data%20in%20one%20of%20the%20cells.%3C%2FP%3E%3CP%3EHow%20can%20I%20prevent%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2429978%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2430040%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2430040%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F39001%22%20target%3D%22_blank%22%3E%40bogi%20sigurdsson%3C%2FA%3E%26nbsp%3BUse%20conditional%20formatting%20(CF)%20for%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20A10%20the%20CF%20rule%20should%20be%20%3DISBLANK(B10)%20and%20in%20B10%20it%20should%20be%26nbsp%3B%3DISBLANK(A10)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2430150%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20in%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2430150%22%20slang%3D%22en-US%22%3EYou%20mean%20data%20validation%3F%3C%2FLINGO-BODY%3E
New Contributor

I have to cells in the same row A10 and B10 

If there is entered data in A10 there should not to be allowed to enter data in B10 and vice versa.

It should only allowed data in one of the cells.

How can I prevent this?

3 Replies

@bogi sigurdsson Use conditional formatting (CF) for this.

 

In A10 the CF rule should be =ISBLANK(B10) and in B10 it should be =ISBLANK(A10)

 

Example attached

You mean data validation?

@bogi sigurdsson Sorry! Yes, Data Validation