Try something like this:

Conditional Formatting
Formula Is:

=--SUBSTITUTE(A2,"<","")$Z2

--
Biff
Microsoft Excel MVP


"f8" wrote in message
...
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!