ExcelBanter - View Single Post

Chip Pearson wrote:
Once the cells are selected, as Ragdyer illustrates, you can
click the Fill button on the Formatting toolbar to change the
background color of the cells.

thank you sooo much.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

wrote in message
ups.com...

Ragdyer wrote:
You could try the elemental "Go To".

Select the range (or the entire sheet) that you'd like to
examine.

Hit <F5,
Click on "Special",

Then, click on <Formulas <OK to have all formula cells
highlighted,
OR ...
Click on <Constants <OK, to have the other data cells
highlighted.
--
HTH,

RD

Thanks that works temporarily(if I click elsewhere the shadings
disappear) ; I want to make the shading of non-formulas
permanent. is
there a way to make that happen ?

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

wrote in message
oups.com...
I have a column where most cells are based on a formula; but
from time
to time I would override selected cells with a plain number.

Is there a way to automatically show (say with a shading)
which cells
in a column are based on formulas and which cells are
directly entered
numbers (the ability to do either one is sufficient, but I'd
like to
know how to do both) ?

Thanks in advance - its amazing how much help one gets in
this ng.