06-28-2007, 09:17 PM
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.
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.