![]() So in addition to that criterion I also needed to identify any value that has "BR" in it, which means "below reading level". Go figure! I wondered if maybe I needed change the format of the text to something more specific other that "Automatic" or "Plain Text", but that did not fix it. But then randomly I noticed it caught "15L" and "0L". ![]() It appeared that it did not catch anything less that or equal to 100L. There were specific values like "90L","70L", "25L", "20L" and so on. The problem though was that is did not catch every value less than 195. For example I need it to color the cells in the column RED if the value is less than ā195Lā (195 Lexile). I need to be able to export data from another source to paste into my Google Sheet and have it conditionally format based on a specific criterion. I am having difficulty writing a custom formula for a Reading Lexile.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |