[ 1 ] Are all the numbers the results of formulas,
OR
[ 2 ] Are all the numbers keyed in,
OR
[ 3 ] Both?

Hit <F5, and click on "Special"

In the "Go To Special" window,

If the answer above is "1"
Click on "Formulas" then <OK,

If the answer above is "2"
Click on "Constants", then <OK,

Then, while the cells are *still* selected, format them to a color you like.

If the answer above was "3", then you'll just have to repeat the "Go To" and
format twice.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"mrharpo2u" wrote in message
...
i havea spread sheet document with over 25K entries spreading six rows.
how
can i shade only the cells hat have numbers in them and leave the blank
cells
with out shade with out doing it each numbered cell at a time. there has
to
be a faster way