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
Highlighted
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
Highlighted

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.