Home

Link different conditional formatted rules to the selected text of another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-833095%22%20slang%3D%22en-US%22%3ELink%20different%20conditional%20formatted%20rules%20to%20the%20selected%20text%20of%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833095%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%209%20different%20conditional%20formatted%20rules%20for%20a%20column%2C%20however%2C%20I%20would%20like%20to%20select%20only%203%20specific%20relevant%20rules%20based%20on%20the%20result%20of%20a%20text%20selected%20from%20a%20drop%20down%20in%20another%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20if%20the%20user%20selected%20text%20'ABC'%20from%20a%20drop%20down%20this%20would%20only%20bring%203%20specific%20conditional%20formatting%20rules%20into%20play%20for%20the%20cell%20on%20the%20same%20row%20as%20the%20text%20selection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-833095%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-833305%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20different%20conditional%20formatted%20rules%20to%20the%20selected%20text%20of%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833305%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401973%22%20target%3D%22_blank%22%3E%40slipstream%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20disable%20the%206%20other%20rules%20by%20adding%20a%20condition%20that%20the%20text%20in%20another%26nbsp%3B%20is%20not%20%22ABC%22.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20in%20your%20conditional%20format%20will%20be%20something%20like%3C%2FP%3E%3CP%3E%3DAND(A1%26lt%3B%26gt%3B%22ABC%22%2C%20%3CEM%3Eother%20conditions)%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA1%20is%20your%20selected%20cell.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
slipstream
Occasional Visitor

Hi,

 

I have created 9 different conditional formatted rules for a column, however, I would like to select only 3 specific relevant rules based on the result of a text selected from a drop down in another cell.

 

So if the user selected text 'ABC' from a drop down this would only bring 3 specific conditional formatting rules into play for the cell on the same row as the text selection.

 

 

1 Reply

@slipstream 

You can disable the 6 other rules by adding a condition that the text in another  is not "ABC". 

The formula in your conditional format will be something like

=AND(A1<>"ABC", other conditions)

 

A1 is your selected cell. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies