{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["bedingte Formatierung"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"bedingte Formatierung","index":0,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Gültig im Bereich B18:J33"]
["Bereich markieren, bedingte Formatierung, neue Regel, Formel zur Ermittlung … (zwei mal!)"]
["Formel 1 ist: =ZEILE()=AktiveZeile"]
["Formel 2 ist: =SPALTE()=AktiveSpalte"]
["Im Modul dieser Tabelle:"]
["Private Sub Worksheet_SelectionChange(ByVal Target As Range)"]
["If Not Intersect(Target, Range(\"B18:J33\")) Is Nothing Then"]
["   ThisWorkbook.Names.Add Name:=\"AktiveZeile\", RefersToR1C1:=Target.Row"]
["   ThisWorkbook.Names.Add Name:=\"AktiveSpalte\", RefersToR1C1:=Target.Column"]
["Else"]
["   On Error Resume Next"]
["   ThisWorkbook.Names(\"AktiveZeile\").Delete"]
["   ThisWorkbook.Names(\"AktiveSpalte\").Delete"]
["   On Error GoTo 0"]
["End If"]
["End Sub"]
[null,"Mo","Di","Mi","Do","Fr","Sa","So","Mo","Di"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x",null,null,{"$f":"COLUMN()","v":13}]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]
[null,"x","x","x","x","x","x","x","x","x"]