Conditional Formatting based on input mask or not meeting your custom format.

Hi

I hope you are all well.

I was wondering if there is a way to highlight cells that do not match your criteria similar to an input mask in Access.

For example:

I am using a right (A4, 7) formula on a phone number to find unique records.

However, the issue occurs when the format I receive has mutliple phone number configurations:
i.e: 1. (XX) XXXX XXXX (perfect)
2. (XX) XX XXXXXX
3. (XX) XXXXXXXX
4. XXXXXXXXXX

Therefore, if there is a way to highlight results that do not come back as X XXXX.

Thanks for any help that is given.

Matt