shading used cells only
Misread original.
Use =ISNUMBER(A1) for the CFFormula is:
Gord Dibben MS Excel MVP
On Mon, 26 Jun 2006 12:32:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote:
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
|