Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    North Carolina, USA
    Thanked 0 Times in 0 Posts

    Format, Etc if Cell Has Formula in it (2003)

    I modified a spreadsheet in a meeting yesterday by adding/subtracting from the cell contents. For example, if cell had 100 in it, I would =100-50 as opposed to hardcoding 50.

    Is it possible to format or do something else to let me know which cells were changed as such. I know I can do control ~ to show but I'd like to see in the other way without having to do control ~...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Format, Etc if Cell Has Formula in it (2003)

    If you want to know which cells contain formulas:
    - Select Edit | Go To... or press Ctrl+G.
    - Click Special...
    - Select Formulas, then click OK.
    All cells containing formulas will be selected. You can loop through them using the Tab key, or you can change their fill color, etc.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Ottawa, Ontario, Canada
    Thanked 1 Time in 1 Post

    Re: Format, Etc if Cell Has Formula in it (2003)

    <P ID="edit" class=small>(Edited by wdwells on 24-Jul-08 07:42. Attachment replaced; Code revised to allow copying and pasting while maintaining audit trail.)</P>If you wish to take a workbook to a meeting and maintain a record of changes to it; the attached workbook provides an example of one approach. On opening the document you are asked if you wish to create an audit trail during the session. If you respond "Yes":

    <UL><LI>you will be given the choice of keeping any existing trail, or deleting it and starting from scratch. Deleting the the existing trail will delete all comments and highlighting in the document;
    <LI>when any cell in the workbook is changed, it will be highlighted Yellow and a comment will be inserted identifying when it was changed, and the value from which it was changed;
    <LI>you will only be able to select one cell at a time[/list]If you respond "No" (you do not wish to create an audit trail), you will be able to operate without the above noted restrictions.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts