In this example, we assume that row 3 is the first row and row 400 is the last row that you want the conditional formatting to be applied to. Then type a range into the Applies to textbox as shown. 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 |