![]() If the word "student" is not the only thing in your target cell, then use the following formula instead: =ISNUMBER(SEARCH("student",$D3)) Just change the 3 to another row number if this is not the case. You said you were looking for the word "student" in column D, and I have assumed that row 3 is the first row that you want this conditional formatting to be applied. button to choose your conditional format (blue text with no fill). Select Use a formula to determine which cells to format, enter the formula as shown below, and then click the Format. (Pictures taken from mix of Windows and Mac versions where possible.) ![]() Admittedly, this answer is based on the Windows version but it should still work for you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |