HIGHLIGHT IN EXCEL

[SMAS59]

Hello,

I am trying to highlight in red, only the phone numbers of parents, within a cell that contains other contact details of said parent. I don't particularly want to comma separate into columns. Is there a way of doing this please, other than by hand, please?

Regards

[TechMonkey]

Do you mean you want the cell highlighted if it contains a phone number? Or just the phone number highlighted?

[SMAS59]

Just the phone number, please.

[MatthewL]

Conditional formatting

[SMAS59]

Thank you. I have tried that but can only seem to highlight the whole cell. Do you have the route please?

[MatthewL]

You would need to use a forumla to determine which cells to format.

 

Probably have a play on something like ChatGPT if you are not up for that.

[SMAS59]

Thank you.

[TechMonkey]

There isn't a formula (that I know of) that will highlight part of the text in a cell. You would need to write a VB script. The alternative is to create a new column and search for the phone number format, extract it and colour the cell if not empty.

[SMAS59]

Many thanks.

[MatthewL]

It is possible with formatting, I have done it in a previous job just dont have the file anymore with the answer in.

[MisterTechMan]

If the cell contains other contact information, you should be able to use the Text to Columns wizard under the Data heading in the menu bar.

 

This will break the contents down into seperate columns and should be easy enough to highlight the phone numbers.