06-28-2007, 07:32 PM
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?
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?