Folks,

yet another conditional formatting question:

I've got bit sheets with numbers, but as they are analytical results, there
are no "0" values, but these are displayed with a leading "<", for example
"<0.0002".

I want to format this with conditional formatting. comparing every cell in a
row with the content of a single cell at the end of that specific row. (Say,
mark all numbers $Z$2, with "10" in $Z$2) The problem is that cell content
with that leading "<" is treated as text and not as a small number and
therefore is erroneously formatted when using the above conditional
formatting method.

Any idea how to get this sorted without changing anything in the
spreadsheet? I need the "<" to stay in place.

Cheers!