Conditional Formatting help

Conditional Formatting help - I think.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Del_N - 08 Feb 2007 19:38 GMT

I am using Excel 2002 in the office and have many worksheets in a workbook.
My first sheet has cells set up as links to the different worksheets. Is it
possible to set up each cell(link) to show when the worksheet it is linked to
has been modified? I want to know if I can have something similar to what
Sharepoint shows when a file has been updated.

Reply to this Message

Mike - 08 Feb 2007 20:35 GMT

I don't think you can do it in the sharepoint way but one possibility (not
very elegant). Assuming your hyperlink to a sheet was in A1

right click the sheet tab you are linking to, view code and paste in this

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("Sheet1").Cells(1, 2).Value = "changed"
End Sub

When the sheet is changed it will write "Changed" in B1 next to the
hyperlink. You can simply delete it from B1 when you acknowledge the change.

> I am using Excel 2002 in the office and have many worksheets in a workbook.
> My first sheet has cells set up as links to the different worksheets. Is it
> possible to set up each cell(link) to show when the worksheet it is linked to
> has been modified? I want to know if I can have something similar to what
> Sharepoint shows when a file has been updated.

Reply to this Message

Del_N - 09 Feb 2007 16:23 GMT

Thank you, this is perfect.

I tested this out and found some things out that I wanted to note. "Sheet1"
should be changed to whatever you have the changed the sheet name to. The 2
in "Cells(1,2)" is which cell column you want the value to appear in. For
example, Column B is 2, Column C is 3, etc. And, "Changed" can be anything
you want to show in the cell for your update notice.

> I don't think you can do it in the sharepoint way but one possibility (not
> very elegant). Assuming your hyperlink to a sheet was in A1
[quoted text clipped - 13 lines]
> > has been modified? I want to know if I can have something similar to what
> > Sharepoint shows when a file has been updated.

Reply to this Message