![]() ![]() ![]() Solution 2: Create a formula to calculate retainer budget. Highlight the cell range, Click on Conditional Formatting > Highlight Cell Rules > Text that Contains to create the Rule, then type YES in the Text that Contains dialog box. It all works absolutely fine and does what I want, until the point too much text has been typed. Our Conditional Formatting rule, then only has to look for the text string YES and apply the formatting when true. Not sure exactly how many characters it works up until, but guessing it’s around 20 or so without having counted specifically. My issue is that conditional formatting by specific text only works up until so many characters, so for large text it is no use. 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. I had started created a spreadsheet to give me assistance with this revision, but it’s not proving successful. I am trying to do a basic bit of conditional formatting to create something to help me with my revision.Īs part of my work studies, I need to learn the definitions of loads of certain words word for word. ![]() Just a query with hope that someone can assist.
0 Comments
Leave a Reply. |