Coloring those larger than five characters with spaces between them
File teaching Color those with more than five characters and spaces between them operation.
Excel Powered Coloring Those Larger Than Five Characters with 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.