Adding new midpoints in conditional formatting is unintuitive, as new midpoint must be between the previous and the next one, requiring for all the midpoints to be changed to accommodate the new one. New midpoints should be automatically put in the right position based on its value.