...verschachtelte Formatierungen gehen wohl nicht..
hier nochmal die "Reinform"
' Diese beiden subs in "DieseArbeitsmappe"
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
' Vor dem Speichern den aktuellen Wert merken
ThisWorkbook.Worksheets("Tabelle2").Cells(1, 1).Value = ThisWorkbook.Worksheets("Tabelle1").Cells(1, 1)
End Sub
Private Sub Workbook_Open()
' beim Öffnen die Hintergrundfarbe der Zelle entfernen
ThisWorkbook.Worksheets("Tabelle2").Cells(1, 1).Value = ThisWorkbook.Worksheets("Tabelle1").Cells(1, 1)
With ThisWorkbook.Worksheets("Tabelle1").Cells(1, 1).Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
' Dieses sub in "Tabelle1"
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A1") Then
Dim dWertGemerkt As Double
' Gemerkten Wert aus Tabelle 2 lesen
datDatumGemerkt = ThisWorkbook.Worksheets("Tabelle2").Cells(1, 1).Value ' Zelle A1
If dWertGemerkt <> ThisWorkbook.Worksheets("Tabelle1").Cells(1, 1) Then
With ThisWorkbook.Worksheets("Tabelle1").Cells(1, 1).Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End If
End If
End Sub