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
I'm using indexOf to perform my count operator as described here: