an example conditional formats with = MID
This is the case for identifying items with strings of numbers and letters that make sense to us.
= MID (A2, 4, 3) take what is in cell A2, it has 4 characters (the first argument of the function) and extract that character and 2 below (which adds 3, the second argument of the function .)
If we extract the final numbers would have to have 8 places to the first value and 6 until the last from this value: = MID (A2, 8, 6)