Posted to microsoft.public.excel.misc

mrharpo2u

Posts: n/a

shading used cells only

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shading a range of cells	Slovenc0417 via OfficeKB.com	Excel Discussion (Misc queries)	1	February 23rd 06 10:05 PM
sort columns, but not shading	on-a-mission	New Users to Excel	3	February 16th 06 06:06 PM
Automatic Shading of Cells	kmmh	Excel Discussion (Misc queries)	1	September 15th 05 08:04 PM
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time	Kevin	Excel Worksheet Functions	1	December 31st 04 12:57 PM

All times are GMT +1. The time now is 01:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us