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 |
$N$10:$NO$26 | 05.Bed.: Formel ist | | =UND(N$2=1;N$2<>"") | | 682978 | | | | | 2 | $N$10:$NO$26 |
$N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25,$N$10:$NO$10,$N$12:$NO$12,$N$14:$NO$14,$N$16:$NO$16,$N$18:$NO$18,$N$20:$NO$20,$N$22:$NO$22,$N$24:$NO$24,$N$26:$NO$26 | 06.Bed.: Zellwert ist | gleich | ="Z" | | 65280 | | | | | 1 | $N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 |
$N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25,$N$10:$NO$10,$N$12:$NO$12,$N$14:$NO$14,$N$16:$NO$16,$N$18:$NO$18,$N$20:$NO$20,$N$22:$NO$22,$N$24:$NO$24,$N$26:$NO$26 | 07.Bed.: Zellwert ist | gleich | ="S" | | 16777215 | | | | | 1 | $N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 |
$N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25,$N$10:$NO$10,$N$12:$NO$12,$N$14:$NO$14,$N$16:$NO$16,$N$18:$NO$18,$N$20:$NO$20,$N$22:$NO$22,$N$24:$NO$24,$N$26:$NO$26 | 08.Bed.: Zellwert ist | gleich | ="K" | | 65535 | | | | | 1 | $N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 |
$N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25,$N$10:$NO$10,$N$12:$NO$12,$N$14:$NO$14,$N$16:$NO$16,$N$18:$NO$18,$N$20:$NO$20,$N$22:$NO$22,$N$24:$NO$24,$N$26:$NO$26 | 09.Bed.: Zellwert ist | gleich | ="U" | | 16777164 | | | | | 1 | $N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 |
$N$11:$NO$43 | 01.Bed.: Formel ist | | =$N$70="S" | | 12611584 | | | | | 2 | $N$11:$NO$43 |
$N$8:$NO$26 | 03.Bed.: Formel ist | | =UND(N$1=1;N$1<>"") | | Test | | | Dünn Umgek. diagon. Gestreift | | 2 | $N$8:$NO$26 |
$N$8:$NO$26 | 04.Bed.: Formel ist | | =UND(N$1=7;N$1<>"") | | Test | | | Dünn Diagon. Gestreift | | 2 | $N$8:$NO$26 |
Bedingte Formatierung Haupttabelle 2 | oberere/unterer Bereich | | |
Wird angewendet auf | Nr. Bed. | Format Zelle | Anhalten | Auswahl | Anzeige | Anzahl | Durchschnitt | Typ | Bereich |
$I$19:$NQ$26,$A$8:$B$26,$NU$19:$XFD$23,$NU$24:$NV$32,$NX$24:$XFD$24,$NZ$25:$XFD$32,$NR$33:$NR$41,$AI$58:$XFD$58,$AI$66:$XFD$67,$NP$59:$XFD$62,$L$62:$NO$62,$L$63:$XFD$64,$L$60:$M$61,$A$70:$B$105,$E$70:$E$105,$1:$7,$A$58:$M$59,$A$68:$F$69,$A$66:$Q$67 | 02.Bed. | | Falsch | | | | | 1 | $I$19:$NQ$26,$A$8:$B$26,$NU$19:$XFD$23,$NU$24:$NV$32,$NX$24:$XFD$24,$NZ$25:$XFD$32,$NR$33:$NR$41,$AI$58:$XFD$58,$AI$66:$XFD$67,$NP$59:$XFD$62,$L$62:$NO$62,$L$63:$XFD$64,$L$60:$M$61,$A$70:$B$105,$E$70:$E$105,$1:$7,$A$58:$M$59,$A$68:$F$69,$A$66:$Q$67 |
$N$10:$NO$26 | 05.Bed. | | Falsch | | | | | 2 | $N$10:$NO$26 |
$N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 | 06.Bed. | | Falsch | | | | | 1 | $N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 |
$N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 | 07.Bed. | | Falsch | | | | | 1 | $N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 |
$N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 | 08.Bed. | | Falsch | | | | | 1 | $N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 |
$N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 | 09.Bed. | | Wahr | | | | | 1 | $N$11:$NO$11,$N$13:$NO$13,$N$15:$NO$15,$N$17:$NO$17,$N$19:$NO$19,$N$21:$NO$21,$N$23:$NO$23,$N$25:$NO$25, $N$10:$NO$10, $N$12:$NO$12, $N$14:$NO$14, $N$16:$NO$16, $N$18:$NO$18, $N$20:$NO$20, $N$22:$NO$22, $N$24:$NO$24, $N$26:$NO$26 |
$N$11:$NO$43 | 01.Bed. | | Falsch | | | | | 2 | $N$11:$NO$43 |
$N$8:$NO$26 | 03.Bed. | | Falsch | | | | | 2 | $N$8:$NO$26 |
$N$8:$NO$26 | 04.Bed. | | Falsch | | | | | 2 | $N$8:$NO$26 |