Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel conditional formatting question
#3
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.
Reply


Messages In This Thread
Re: Excel conditional formatting question - by cbelt3 - 06-28-2007, 09:17 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)