..

%3CLINGO-SUB%20id%3D%22lingo-sub-2142153%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142153%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20want%20to%20highlight%20cells%20that%20contain%20a%20specific%20symbol%20and%20have%20more%20than%203%20characters%20before%20that%20symbol%20and%20no%20space%20in%20between%20words.%20What%20formula%20do%20I%20need%20to%20use%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2142153%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142553%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F969196%22%20target%3D%22_blank%22%3E%40itaychristian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20the%20range%20you%20want%20to%20format%20is%20B2%3AB50%2C%20and%20that%20the%20symbol%20is%20%22%26amp%3B%22.%3C%2FP%3E%0A%3CP%3ESelect%20this%20range.%3C%2FP%3E%0A%3CP%3EI'll%20assume%20that%20B2%20is%20the%20active%20cell%20in%20the%20selection.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20select%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3C%2FP%3E%0A%3CP%3ESelect%20'Use%20a%20formula%20to%20determine%20which%20cells%20to%20format'.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DAND(FIND(%22%26amp%3B%22%2CB2)%26gt%3B4%2CISERROR(FIND(%22%20%22%2CB2)))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3EActivate%20the%20Fill%20tab.%3C%2FP%3E%0A%3CP%3ESelect%20a%20highlight%20color.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

..

1 Reply

@Deleted 

Let's say the range you want to format is B2:B50, and that the symbol is "&".

Select this range.

I'll assume that B2 is the active cell in the selection.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

=AND(FIND("&",B2)>4,ISERROR(FIND(" ",B2)))

Click Format...

Activate the Fill tab.

Select a highlight color.

Click OK, then click OK again.