Results 1 to 10 of 10
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Scotland
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional format a Highlighted Cell (2K 9.0.4402

    Is it possible to get conditional format to identify a cell that has a highlight comment against it in share mode. I want to be able to change the background colour of the cell to allow people sharing the workbook to see the changes more easily.

    Thanks in advance

    Angus

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional format a Highlighted Cell (2K 9.0.4402

    I'm not sure what you mean by "a cell that has a highlight comment against it". Could you explain?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional format a Highlighted Cell (2K 9.0.4402

    I am not sure what a highlight comment is? If I can clarify... Are you wanting conditional format to shade a cell in which an inserted comment has been modified?
    Regards,
    Rudi

  4. #4
    Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Scotland
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional format a Highlighted Cell (2K 9.0.

    If you share the workbook, then you can use the highlight changes button to get a similar option to that of track changes in Word which will comment any changes to a cell. This like a comment box appears against the cell changed. I would like to make the change stronger by colouring the cell background.

    Cheers

    Angus

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional format a Highlighted Cell (2K 9.0.

    This is not what you want to hear, but I strongly recommend *not* sharing a workbook. It may cause the workbook to become corrupted; Excel doesn't handle sharing very well.

    Apart from that, I don't see any way to do what you want.

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional format a Highlighted Cell (2K 9.0.

    Just to extent Hans's warning, see this page: Losing Data in a Shared Workbook
    I am also not keen on the feature, though it sounds great to use. (My opinion)
    Regards,
    Rudi

  7. #7
    Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Scotland
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional format a Highlighted Cell (2K 9.0.

    I was trying to highlight changes between different versions of a file that another colleague uses. We had some finger trouble which would have been easier to see if we had some means of being able to see which parts of the workbook had been changed. I want to be able to say that if all of the key cells are green then you are ready to go.

    Cheers

    Angus

  8. #8
    Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Scotland
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional format a Highlighted Cell (2K 9.0.

    In this instance this will not be the case as there will only one person accessing and updating the sheet. My reason is to allow a check that the key cells which require to be updated on a monthly basis have.

    Cheers

    Angus

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional format a Highlighted Cell (2K 9.0.

    There are ways of comparing two physically different versions of a spreadsheet (Budget1.xls and Budget2.xls).
    There doesn't appear to be much support for handling changes in a shared workbook other than the built-in options.

  10. #10
    Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Scotland
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional format a Highlighted Cell (2K 9.0.

    I will have a think about approaching it from the angle of comparing the month before against this months spreadsheet.

    Cheers

    Angus

Posting Permissions

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