Bedingte Formatierung Haupttabelle 1 | |
Wird angewendet auf | Nr. Bed. Regeltyp | Operator | Formel1 | Formel2 | Format Schrift Füll-farbe | Unterstrichen | Schrift- farbe | Muster | Muster-farbe | Typ | Bereich |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 02.Bed.: Formel ist | | =ODER(RECHTS(C7;1)="B") | | 16711935 | | 16777215 | | | 2 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 03.Bed.: Zellwert ist | gleich | ="ZA" | | 0 | | 16777215 | | | 1 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 04.Bed.: Zellwert ist | gleich | ="BF" | | 9359529 | | 16777215 | | | 1 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 05.Bed.: Zellwert ist | gleich | ="U" | | 6723891 | | 16777215 | | | 1 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 06.Bed.: Formel ist | | =RECHTS(C7;1)="K" | | 255 | | 16777215 | | | 2 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$B$43:$B$73,$M$43:$M$73,$X$43:$X$72,$AI$43:$AI$73,$AT$43:$AT$72,$BE$43:$BE$73,$BE$7:$BE$36,$X$7:$X$37,$AI$7:$AI$36,$AT$7:$AT$37,$M$7:$M$34,$B$7:$B$37 | 01.Bed.: Formel ist | | =WENN(ISTFEHLER(VERGLEICH(B7;$EG$5:$EG$23;0));0;1) | | 16711680 | | 16777215 | Uni | | 2 | $B$43:$B$73,$M$43:$M$73,$X$43:$X$72,$AI$43:$AI$73,$AT$43:$AT$72,$BE$43:$BE$73,$BE$7:$BE$36,$X$7:$X$37,$AI$7:$AI$36,$AT$7:$AT$37,$M$7:$M$34,$B$7:$B$37 |
$B$43:$B$73,$M$43:$M$73,$X$43:$X$72,$AI$43:$AI$73,$AT$43:$AT$72,$BE$43:$BE$73,$BE$7:$BE$36,$X$7:$X$37,$AI$7:$AI$36,$AT$7:$AT$37,$M$7:$M$34,$B$7:$B$37 | 02.Bed.: Formel ist | | =ODER(WOCHENTAG(B7)=1) | | 12632256 | | | | | 2 | $B$43:$B$73,$M$43:$M$73,$X$43:$X$72,$AI$43:$AI$73,$AT$43:$AT$72,$BE$43:$BE$73,$BE$7:$BE$36,$X$7:$X$37,$AI$7:$AI$36,$AT$7:$AT$37,$M$7:$M$34,$B$7:$B$37 |
$C$2:$G$1048576 | 01.Bed.: Formel ist | | =UND(C1="";WOCHENTAG($B2;2)=1;C2<>"") | | 255 | | | | | 2 | $C$2:$G$1048576 |
$C$7:$G$7 | 08.Bed.: Formel ist | | =UND(C5="";WOCHENTAG($B7;2)=1;C7<>"") | | 255 | | | | | 2 | $C$7:$G$7 |
Bedingte Formatierung Haupttabelle 2 | oberere/unterer Bereich | | |
Wird angewendet auf | Nr. Bed. | Format Zelle | Anhalten | Auswahl | Anzeige | Anzahl | Durchschnitt | Typ | Bereich |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 02.Bed. | | Falsch | | | | | 2 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 03.Bed. | | Falsch | | | | | 1 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 04.Bed. | | Falsch | | | | | 1 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 05.Bed. | | Wahr | | | | | 1 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 06.Bed. | | Wahr | | | | | 2 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 | 07.Bed. | | Wahr | | | | | 2 | $AU$7:$AY$37,$N$7:$R$35,$Y$7:$AC$37,$AJ$7:$AN$36,$BF$7:$BJ$36,$BF$43:$BJ$73,$AU$43:$AY$72,$AJ$43:$AN$73,$Y$43:$AC$72,$C$43:$G$73,$N$43:$R$73,$C$7:$G$37 |
$B$43:$B$73,$M$43:$M$73,$X$43:$X$72,$AI$43:$AI$73,$AT$43:$AT$72,$BE$43:$BE$73,$BE$7:$BE$36,$X$7:$X$37,$AI$7:$AI$36,$AT$7:$AT$37,$M$7:$M$34,$B$7:$B$37 | 01.Bed. | | Wahr | | | | | 2 | $B$43:$B$73,$M$43:$M$73,$X$43:$X$72,$AI$43:$AI$73,$AT$43:$AT$72,$BE$43:$BE$73,$BE$7:$BE$36,$X$7:$X$37,$AI$7:$AI$36,$AT$7:$AT$37,$M$7:$M$34,$B$7:$B$37 |
$B$43:$B$73,$M$43:$M$73,$X$43:$X$72,$AI$43:$AI$73,$AT$43:$AT$72,$BE$43:$BE$73,$BE$7:$BE$36,$X$7:$X$37,$AI$7:$AI$36,$AT$7:$AT$37,$M$7:$M$34,$B$7:$B$37 | 02.Bed. | | Wahr | | | | | 2 | $B$43:$B$73,$M$43:$M$73,$X$43:$X$72,$AI$43:$AI$73,$AT$43:$AT$72,$BE$43:$BE$73,$BE$7:$BE$36,$X$7:$X$37,$AI$7:$AI$36,$AT$7:$AT$37,$M$7:$M$34,$B$7:$B$37 |
$C$2:$G$1048576 | 01.Bed. | | Falsch | | | | | 2 | $C$2:$G$1048576 |
$C$7:$G$7 | 08.Bed. | | Falsch | | | | | 2 | $C$7:$G$7 |