SOLVED

Conditional Formatting Based off Number of Characters

%3CLINGO-SUB%20id%3D%22lingo-sub-3131578%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20Based%20off%20Number%20of%20Characters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3131578%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20some%20basic%20conditional%20formatting%20based%20off%20of%20a%20initial%20character%20string.%20If%20trimmed%20character%20sting%20equals%2012%20characters%20I%20would%20like%20the%20cell%20to%20remain%20without%20formatting.%20If%20the%20string%20does%20not%20equal%2012%20characters%20I'd%20like%20the%20cell%20to%20be%20highlighted%20in%20Red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECase%20number%20in%20this%20instance%20is%20a%20calculated%20filed%20based%20off%20the%20first%20space%26nbsp%3B%3C%2FP%3E%3CP%3E%3DLEFT(%5BTitle%5D%2C(FIND(%22%20%22%2C%5BTitle%5D%2C1)-1))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20indexOf%20to%20perform%20my%20count%20operator%20as%20described%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dk5bSKcMiJcc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EString%20length%20detection%20trick%20to%20extend%20your%20column%20and%20view%20formatting%20options%20-%20YouTube%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20different%20examples%20that%20I've%20tried%20but%2C%20I'm%20not%20entirely%20sure%20why%20the%20output%20comes%20out%20incorrectly!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEquals%2012%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JohnSena_0-1644261700661.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345950i90052904EA77017F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JohnSena_0-1644261700661.png%22%20alt%3D%22JohnSena_0-1644261700661.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20Equal%2012%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JohnSena_1-1644261700663.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345952iB91E0AB5BDBA09DF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JohnSena_1-1644261700663.png%22%20alt%3D%22JohnSena_1-1644261700663.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreater%20than%2012%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JohnSena_2-1644261700665.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345951iF985C039EF3BC412%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JohnSena_2-1644261700665.png%22%20alt%3D%22JohnSena_2-1644261700665.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELess%20than%2012%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JohnSena_3-1644261700666.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345953iB3DCB21009600848%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JohnSena_3-1644261700666.png%22%20alt%3D%22JohnSena_3-1644261700666.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3131578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20List%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am trying to create some basic conditional formatting based off of a initial character string. If trimmed character sting equals 12 characters I would like the cell to remain without formatting. If the string does not equal 12 characters I'd like the cell to be highlighted in Red.

 

Case number in this instance is a calculated filed based off the first space 

=LEFT([Title],(FIND(" ",[Title],1)-1))

 

I'm using indexOf to perform my count operator as described here:

String length detection trick to extend your column and view formatting options - YouTube

 

Here are the different examples that I've tried but, I'm not entirely sure why the output comes out incorrectly!

 

Equals 12

 

JohnSena_0-1644261700661.png

 

 

 

Not Equal 12

JohnSena_1-1644261700663.png

 

 

 

 

Greater than 12

JohnSena_2-1644261700665.png

 

 

 

 

Less than 12

JohnSena_3-1644261700666.png

 

 

 

 

1 Reply
best response confirmed by JohnSena (New Contributor)
Solution

@JohnSena I'm an idiot. I had my number in '' which made it a string not a number.