I have a spreadsheet where I record water sample results,
I want to add conditional formatting to highlight cells that exceed the limits for the parameters being tested,
However some results come in the form of <0.10, so even if my limit is 1.0, any cell with a less than symbol will also get highlighted,

Is there anyway around this?