The Undergraduate Advising Office is here to help you find answers. Our advisors have prepared a list of Frequently Asked Questions about courses and credits. If you don't find an answer to your question there, please contact the advising office by emailing bioadv@indiana.edu or calling (812) 855-3810.he Undergraduate Advising Office is here to help you find answers. Our advisors have prepared a list of Frequently Asked Questions about courses and credits. If you don't find an answer to your question there, please contact the advising office by emailing bioadv@indiana.edu or calling (812) 855-3810.
If a cell contains a specific text than return a value Everywhere I search I see this formula for looking in a column and if a row contains a specific value then to return x, if not return y. =IF(ISNUMBER(SEARCH(text, A1)),X,Y) But when I use this in Excel 2010 I get an error. I modify it to look like this...
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.