Wildcard characters can be used with the "Text contains" or "Text does not contain" fields while formatting. You can use wildcard characters to match multiple expressions. Often, you will need to add dollar signs ($) in front of letters and numbers in formulas so that the formatting is applied using absolute references as opposed to relative references (A1 to B1, A2 to B2). For example, if you want to make the whole row green if the value in column B is "Yes", write a formula like "=$B1="Yes"."
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |