+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Excel conditional formatting question (/showthread.php?tid=35699)
Excel conditional formatting question - davester - 06-28-2007
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?
Re: Excel conditional formatting question - space-time - 06-28-2007
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!
Re: Excel conditional formatting question - cbelt3 - 06-28-2007
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.