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.