Home

Conditionnal formatting advanced

%3CLINGO-SUB%20id%3D%22lingo-sub-282772%22%20slang%3D%22en-US%22%3EConditionnal%20formatting%20advanced%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282772%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20multiple%20choice%20cell%20with%200%2C1%2C2.%20let's%20call%20it%20cell%20A%3C%2FP%3E%3CP%3EI%20have%20another%20multiple%20choice%20cell%20with%20Yes%20or%20No%20choices.%20Let's%20call%20it%20cell%20B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20cell%20A%20equals%200%2C%20I%20want%20cell%20B%20to%20return%20NO%20in%20red%3C%2FP%3E%3CP%3EIf%20cell%20A%20equals%201%20or%202%2C%20I%20want%20to%20be%20able%20to%20choose%20between%20yes%20or%20no%20in%20cell%20B%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%20Thx%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-282772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282849%22%20slang%3D%22en-US%22%3ERe%3A%20Conditionnal%20formatting%20advanced%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282849%22%20slang%3D%22en-US%22%3EIt's%20exactly%20what%20i%20needed!%20thank%20you%20very%20much%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282846%22%20slang%3D%22en-US%22%3ERe%3A%20Conditionnal%20formatting%20advanced%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282846%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20check%20the%20attached%20file%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
berthetwilliam
New Contributor

Hi everyone,

 

I have a multiple choice cell with 0,1,2. let's call it cell A

I have another multiple choice cell with Yes or No choices. Let's call it cell B

 

If cell A equals 0, I want cell B to return NO in red

If cell A equals 1 or 2, I want to be able to choose between yes or no in cell B;

 

Any ideas? Thx 

2 Replies

Please check the attached file:

 

It's exactly what i needed! thank you very much
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies