Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Track Changes (Excel 2002)

    I sent my excel worksheet to someone else to make changes. When they are completed making changes they will send it to another co-work to make changes. How can I control what color the changes will be went they come back to me. I don't like yellow but some changes came back as yellow. Can I cpntrol what colors are used when changes come back to me??

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Track Changes (Excel 2002)

    Not that I can see! Perhaps someone else will have a suggestion.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Track Changes (Excel 2002)

    You can alter the color scheme of any workbook.

    Go to Tools, Options and select color. You can then select each standard color ( the yellows in your case ) you want to replace, click Modify and create a suitable replacement . Just bear in mind that all instances of that color in the active workbook will be replaced with you new choice. But if you do not like yellow that would probably not be a problem.

    Andrew C

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Track Changes (Excel 2002)

    Thanks Andrew <img src=/S/bow.gif border=0 alt=bow width=15 height=15>
    Odd that since they have a colour scheme that you can't point to a specific area where colour is used and set the colour (like PPT). Would be easier. Maybe the Excel programmers and PPT programmers have to go out to lunch <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Track Changes (Excel 2002)

    < Maybe the Excel programmers and PPT programmers have to go out to lunch >

    They might invite the Word guys along also.

    Andrew

  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Track Changes (Excel 2002)

    It has always amazed me how long it takes to get features from one application into another.
    Maybe more than lunch is required <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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