recognising values

I am entering trace element test results into a spreadsheet which has conditional formating to change the color of the cell if the value is over the accepted maximum. some of the values are proceeded by a "<" symbol as in "<6.2", is there any way to make excel recognise this as the value "6.2" for the conditional formating but still display "<6.2".
Any help would be much appreciated.
Marcus