Home

Conditional formatting values to tell user to leave a cell blank

%3CLINGO-SUB%20id%3D%22lingo-sub-877357%22%20slang%3D%22en-US%22%3EConditional%20formatting%20values%20to%20tell%20user%20to%20leave%20a%20cell%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-877357%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20working%20on%20a%20sheet%20whereby%20we%20need%20to%20tell%20users%20to%20not%20fill%20in%20a%20cell%20based%20on%20previous%20selected%20values.%20e.g.%20Column%20A%20Row%20A%20user%20selects%20item%20from%20droplist%3B%20based%20on%20value%20selected%20user%20does%20or%20does%20not%20need%20to%20enter%20free-text%20into%20Column%20B%2C%20Row%20A.%20Is%20there%20any%20way%20Excel%20can%20tell%20the%20user%20to%20not%20fill%20in%20a%20cell%20if%20not%20needed%20based%20on%20selected%20value%20(coloring%20cell%2C%20or%20populating%20text%20in%20cell%20%22N%2FA%22%2C%20anything%20like%20that).%3CBR%20%2F%3EMy%20use%20case%20involves%20two%20drop-lists%20(Col%20A%2C%20Col%20B%20-%20B%20values%20dependent%20on%20A's%20selection)%3B%20with%2020%20free-text%20columns%20after%20that%20(user%20only%20needs%20to%20fill%20out%20some%20of%20these%20columns%20based%20on%20combination%20of%20A%20%26amp%3B%20B's%20selection).%20Each%20row%20may%20have%20a%20different%20combination%20between%20A%20%26amp%3B%20B%20(but%20same%20drop-list%20values).%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-877357%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-879173%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20values%20to%20tell%20user%20to%20leave%20a%20cell%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879173%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415849%22%20target%3D%22_blank%22%3E%40kelly100%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20sounds%20like%20you%20could%20use%20an%20OR()%20statement%20to%20satisfy%20your%20conditional%20formatting%20requirements.%20You%20could%20format%20those%20cells%20that%20the%20conditional%20formats%20are%20true%20as%20black%20filled%20cells%20to%20defer%20the%20users%20from%20inputting%20information%20into%20those%20cells.%20Without%20seeing%20a%20sample%20of%20your%20data%2C%20however%2C%20it%20would%20be%20difficult%20to%20explain%20a%20proper%20formula%20and%20conditional%20format%20for%20your%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
kelly100
Occasional Visitor

I am currently working on a sheet whereby we need to tell users to not fill in a cell based on previous selected values. e.g. Column A Row A user selects item from droplist; based on value selected user does or does not need to enter free-text into Column B, Row A. Is there any way Excel can tell the user to not fill in a cell if not needed based on selected value (coloring cell, or populating text in cell "N/A", anything like that).
My use case involves two drop-lists (Col A, Col B - B values dependent on A's selection); with 20 free-text columns after that (user only needs to fill out some of these columns based on combination of A & B's selection). Each row may have a different combination between A & B (but same drop-list values).

Thanks!

1 Reply

Hello @kelly100,

 

It sounds like you could use an OR() statement to satisfy your conditional formatting requirements. You could format those cells that the conditional formats are true as black filled cells to defer the users from inputting information into those cells. Without seeing a sample of your data, however, it would be difficult to explain a proper formula and conditional format for your data.

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