Ted Lewis (born 18 October 1969 in Bellingham, Massachusetts) is an American voice actor who does work for 4kids Entertainment, Central Park Media, TAJ Productions, DuArt Film and Video, and NYAV Post. Primarily, he is involved with anime dub voice work. He is also known as Ed Paul.
If you want to use the value of a cell in a formula in another cell of the spreadsheet, then you refer to this cell by means of its cell address. This cell address consists of a column indicator and a row number, e.g. cell D14 is the cell in column D, row 14.
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: =ISNUMBER(SEARCH(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.