How this formula worksWhen you use a formula to apply conditional formatting, the formula is evaluated relative to the active cell in the selection at the time the rule is created. = ( ( 'dog',B2 ))Note: with conditional formatting, it's important that the formula be entered relative to the 'active cell' in the selection, which is assumed to be B2 in this case. However, if you want more flexibility, you can use your own formula, as explained in this article.If you want to highlight cells that contain certain text, you can use a simple formula that returns TRUE when a cell contains the text (substring) that you specify.For example, if you want to highlight any cells in the range B2:B11 that contain the text 'dog', you can use. Note: Excel contains many built-in 'presets' for highlighting values with conditional formatting, including a preset to highlight cells that contain specific text.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |