Excel conditional formatting question

[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.