Conditional Formatting "if text includes a phone number"

Welcome to the forum.

This formula works to check if a cell (A2) contains a number, returning TRUE if it does:

Formula:

Please Login or Register  to view this content.

Unfortunately, Excel won't allow the use of arrays in conditional formats, so you can't use this directly as the CF formula. What you can do is insert an extra 'helper column' (let's say a new column B) containing the above formula then use CF based on that helper column (which you can hide - it'll still work).

So, step by step (this assumes the column you want to highlight is column A and data starts on row 2 - adjust as necessary for your actual column letter and start row):
1. Insert a new column to the right of column A.
2. In B2, enter this:

Formula:

Please Login or Register  to view this content.

3. Drag down as far as you need.
4. Select your data in column A (let's say A2:A100).
5. On the Home tab of the ribbon, click 'Conditional Formatting', then 'New Rule', then 'Use a formula to determine which cells to format'.
6. In the formula box, enter this:

Formula:

Please Login or Register  to view this content.

7. Click 'Format' then the 'Font' tab and choose 'Bold' format.
8. Click OK twice to get back to the worksheet.
9. (Optional) Hide the helper column B.

Hope that does what you want.

I don't 0 think 5 here 6 is a 7 phone number

TRUE

I don't 0 think 5 here 6 is a 7 phone number

={COUNT(SEARCH({0,1,2,3,4,5,6,7,8,9},A1))>0}

Could you attached samples file, please?
Maybe we can find solution with more information about syntax of your data.

Kokosek makes a good point. My answer in post 2 assumes that the only cells with numbers in are those which contain phone numbers. If that is not the case, then we'll need to know more about how the information in the cells is organised.