You can use a formula like this: ISNUMBER(FIND("HYPERLINK";FORMULA(A2)))
From RTL in the formula▸we look for the word HYPERLINK▸ if it is found the result is a number;