A column shows the formula contains the string, I search A column contains A substring with VBA, if found, the (VBA) changes the color of the substring to red, for example, A1 cell's formula is="CSDN" "& amp; BBS ", search to BBS, will "BBS" is changed to red, but the VBA cannot be changed to red, if A1 cell is not a formula, but "CSDN BBS", VBA program will "BBS" red word instead, this is what reason, how to deal with? Trouble expert help, thank you very much!