Select the range of cell. Assuming A1:F25000

FormatConditional FormattingFormula is.

=A1<""

Format to a nice color and OK.


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 11:57:02 -0700, mrharpo2u
wrote:

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