title: Conditional Formatting based on number in a cell that contains both text and numbers
body: <p>If cell A1 has the value "600 T" is there a way to apply the number less than/between/greater than conditonal formatting based on the number, essentially ignoring any text that may be in the cell?</p>