Home

Here's a real Conditional Formating challenge

%3CLINGO-SUB%20id%3D%22lingo-sub-461581%22%20slang%3D%22en-US%22%3EHere's%20a%20real%20Conditional%20Formating%20challenge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-461581%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20simplified%20version%20of%20what%20I%20really%20need%2C%20but%20is%20there%20a%20way%20to%20get%20A1%20to%20%3CSTRONG%3Eget%20its%20cell%20format%20from%20a%20%22list%22%3C%2FSTRONG%3E%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EEx%3A%3C%2FP%3E%3CP%3EB1%20is%20red%20and%20has%20%22goodbye%22%20in%20it.%3C%2FP%3E%3CP%3EB2%20is%20blue%20and%20has%20%22hello%22%20in%20it.%3C%2FP%3E%3CP%3EI'd%20like%20A1%20to%20turn%20blue%20if%20I%20write%20%22hello%22%20in%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20get%20A1%20to%20change%20its%20cell%20format%20to%20match%20the%20cell%20format%20of%20the%20equivalent%20value%20in%20B%3AB.%20There%20are%20more%20than%2045%20choices%20so%20I'm%20looking%20for%20a%20way%20to%20do%20this%20without%20having%20to%20enter%2045%2B%20different%20conditions%20in%20each%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20someone%20is%20up%20for%20the%20challenge%20and%20that%20this%20can%20actually%20be%20done%20in%20some%20way!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-461581%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-461907%22%20slang%3D%22en-US%22%3ERe%3A%20Here's%20a%20real%20Conditional%20Formating%20challenge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-461907%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322030%22%20target%3D%22_blank%22%3E%40Velkyn%3C%2FA%3E%26nbsp%3B%2C%20in%20general%20one%20color%20-%20one%20rule.%20It's%20not%20necessary%20to%20define%20it%20for%20each%20cell%20separately%20%2C%20but%20if%20would%20like%20to%20have%2045%20colors%20you%20have%20to%20define%2045%20rules.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Velkyn
Occasional Visitor

This is a simplified version of what I really need, but is there a way to get A1 to get its cell format from a "list"?


Ex:

B1 is red and has "goodbye" in it.

B2 is blue and has "hello" in it.

I'd like A1 to turn blue if I write "hello" in it.

 

How do I get A1 to change its cell format to match the cell format of the equivalent value in B:B. There are more than 45 choices so I'm looking for a way to do this without having to enter 45+ different conditions in each cells.

 

Hope someone is up for the challenge and that this can actually be done in some way!

1 Reply

@Velkyn , in general one color - one rule. It's not necessary to define it for each cell separately , but if would like to have 45 colors you have to define 45 rules.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 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