Excel conditional formatting question

[davester]

I have a very long list of numbers that I want to apply formatting to. The list looks something like this:

0.0035
0.0024
<0.001
0.05
<0.0001

I want all the cells that are numbers to be bold and all the cells with "<" signs to be shaded grey. I have fiddled with the conditional formatting dialogue box, using the "isnumber" function mostly, but it doesn't seem to work. Any ideas?

[space-time]

the list is only "numbers" or "
then make ALL BOLD, and then apply the following conditional formatting:

"Cell Values Is" then choose "greater than" and finally type "<" (without ").

Then choose format: font REGULAR (you get rid of BOLD) and also select a color.

Done!

[cbelt3]

nope, that won't necessarily work. Here is a cheating-er way to do it

Set conditional formatting for the cell to "Formula"
Formula is:
=ISERROR(VALUE(A2))
(Where A2 is the cell address- it will try to put $ in there, take 'em out and the format will transfer nicely to all your cells)

Any cell that is NOT a full number will then have conditional formatting applied to it.