Color those with more than five characters and spaces between them

File teaching Color those with more than five characters and spaces between them operation.

Excel Powered Color Those with More Than Five Characters and Spaces Between Them

The number of characters is calculated with the LEN function. Gap control is done with the FIND function. Conditional formatting formula mode is used. Cells that comply with the condition are painted with the specified color. The rules apply collectively to the table.

Hope it is useful.