distinguishing formula cells
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.
|