Conditional Formatting specific text character limit to function

%3CLINGO-SUB%20id%3D%22lingo-sub-1695968%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20specific%20text%20character%20limit%20to%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1695968%22%20slang%3D%22en-US%22%3EHi%20everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3EJust%20a%20query%20with%20hope%20that%20someone%20can%20assist.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20do%20a%20basic%20bit%20of%20conditional%20formatting%20to%20create%20something%20to%20help%20me%20with%20my%20revision.%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20part%20of%20my%20work%20studies%2C%20I%20need%20to%20learn%20the%20definitions%20of%20loads%20of%20certain%20words%20word%20for%20word.%20I%20had%20started%20created%20a%20spreadsheet%20to%20give%20me%20assistance%20with%20this%20revision%2C%20but%20it%E2%80%99s%20not%20proving%20successful.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20column%20A%20Is%20all%20the%20words%2C%20in%20column%20B%20is%20all%20the%20full%20written%20definitions%20for%20each%20word%2C%20and%20then%20column%20C%20is%20blank%2C%20but%20i%20have%20tried%20putting%20in%20conditional%20highlighting%20for%20specific%20text%2C%20so%20that%20I%20can%20type%20my%20attempts%20at%20the%20definition%20within%20column%20C%2C%20and%20the%20format%20is%20set%20to%20be%20red%20when%20the%20text%20doesn%E2%80%99t%20match%20column%20B%2C%20but%20go%20green%20when%20it%20does%20match.%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20issue%20is%20that%20conditional%20formatting%20by%20specific%20text%20only%20works%20up%20until%20so%20many%20characters%2C%20so%20for%20large%20text%20it%20is%20no%20use.%20Not%20sure%20exactly%20how%20many%20characters%20it%20works%20up%20until%2C%20but%20guessing%20it%E2%80%99s%20around%2020%20or%20so%20without%20having%20counted%20specifically.%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20all%20works%20absolutely%20fine%20and%20does%20what%20I%20want%2C%20until%20the%20point%20too%20much%20text%20has%20been%20typed.%20Is%20there%20a%20way%20this%20text%20limit%20can%20be%20overwritten%20so%20that%20conditional%20highlighting%20will%20still%20work%20regardless%20of%20how%20much%20text%20there%20is%3F%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20otherwise%20is%20there%20another%20route%20I%20can%20take%20to%20create%20the%20same%20effect%3F%20Thanks%20in%20advance!%3CBR%20%2F%3E%3CBR%20%2F%3EJust%20a%20little%20something%20that%20would%20be%20good%20to%20help%20me%20that%E2%80%99s%20just%20an%20annoying%20little%20thing%20preventing%20it%20from%20working!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1695968%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor
Hi everyone,

Just a query with hope that someone can assist.

I am trying to do a basic bit of conditional formatting to create something to help me with my revision.

As part of my work studies, I need to learn the definitions of loads of certain words word for word. I had started created a spreadsheet to give me assistance with this revision, but it’s not proving successful.

In column A Is all the words, in column B is all the full written definitions for each word, and then column C is blank, but i have tried putting in conditional highlighting for specific text, so that I can type my attempts at the definition within column C, and the format is set to be red when the text doesn’t match column B, but go green when it does match.

My issue is that conditional formatting by specific text only works up until so many characters, so for large text it is no use. Not sure exactly how many characters it works up until, but guessing it’s around 20 or so without having counted specifically.

It all works absolutely fine and does what I want, until the point too much text has been typed. Is there a way this text limit can be overwritten so that conditional highlighting will still work regardless of how much text there is?

Or otherwise is there another route I can take to create the same effect? Thanks in advance!

Just a little something that would be good to help me that’s just an annoying little thing preventing it from working!
1 Reply

@MattyOlliver 

 

This worked for me.

BXLConditionalFormatting.png

I'm using Office 365. I tested it on this text (including the carriage returns) which is far more than 20 words. 

 

"In column A Is all the words, in column B is all the full written definitions for each word, and then column C is blank, but i have tried putting in conditional highlighting for specific text, so that I can type my attempts at the definition within column C, and the format is set to be red when the text doesn’t match column B, but go green when it does match.

 

My issue is that conditional formatting by specific text only works up until so many characters, so for large text it is no use. Not sure exactly how many characters it works up until, but guessing it’s around 20 or so without having counted specifically.

 

It all works absolutely fine and does what I want, until the point too much text has been typed. Is there a way this text limit can be overwritten so that conditional highlighting will still work regardless of how much text there is?"