SOLVED

Bedingte Formatierung mit mehreren Kriterien

%3CLINGO-SUB%20id%3D%22lingo-sub-2711849%22%20slang%3D%22de-DE%22%3EConditional%20formatting%20with%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2711849%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20several%20criteria%20that%20affect%20the%20formatting%20of%20a%20particular%20area.%3C%2FP%3E%3CP%3EThe%20formatting%20should%20be%20changed%20accordingly%20with%20a%20drop-down%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShortlist%20would%20be%3A%3C%2FP%3E%3CP%3EPrint%20view%3C%2FP%3E%3CP%3EScreen%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20print%20view%2C%20all%20cells%20in%20the%20defined%20area%20that%20contain%20text%20should%20be%20filled%20in%20black.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20screen%20view%2C%20the%20cells%20should%20be%20colored%20green%2C%20red%2C%20yellow%20or%20blue%20according%20to%20the%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2711849%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2712196%22%20slang%3D%22en-US%22%3ERe%3A%20Bedingte%20Formatierung%20mit%20mehreren%20Kriterien%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2712196%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1144629%22%20target%3D%22_blank%22%3E%40Paul_Wise%3C%2FA%3E%20You%20already%20have%20working%20rules%20for%20B6%3AE13.%20You%20only%20need%20to%20add%20a%20rule%20to%20color%20B19%3AE26%20black%20if%20%24A%242%3D%22Druckansicht%22%3C%2FP%3E%0A%3CP%3EAm%20I%20missing%20something%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2715472%22%20slang%3D%22de-DE%22%3ERe%3A%20Conditional%20formatting%20with%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2715472%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3Evogelaar%20%40Hans%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20I%20select%20the%20print%20view%2C%20all%20cells%20should%20be%20colored%20black%20with%20a%20text.%3C%2FP%3E%3CP%3EI%20don't%20have%20the%20idea%20of%20how%20to%20solve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ECondition%20for%20B6%3AE13%20would%20be%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIf%20A2%3DPrint%20View%20%26amp%3B%20Cell%20contains%20text%20in%20this%20area%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hallo,

 

ich habe mehrere Kriterien, welche die Formatierung eines bestimmten Bereichs beeinflussen.

Die Formatierung soll mit einem Dropdownfeld entsprechend geändert werden.

 

Auswahlliste wäre:

Druckansicht

Bildschirmansicht

 

In der Druckansicht sollen alle Zellen in dem definierten Bereich, die einen Text enthalten schwarz ausgefüllt werden.

 

Bei der Bildschirmansicht sollen die Zellen entsprechend des Textes grün, rot, gelb oder blau eingefärbt werden.

 

Beste Grüße

Paul

4 Replies

@Paul_Wise You already have working rules for B6:E13. You only need to add a rule to color B19:E26 black if $A$2="Druckansicht"

Am I missing something?

@Hans Vogelaar 

wenn ich die Druckansicht auswähle, sollen sämtliche zellen mit einem Text schwarz gefärbt werden.

Hierfür fehlt mir die Idee, wie ich das lösen kann.

 

Bedingung für B6:E13 wäre:

Wenn A2=Druckansicht & Zelle in diesem Bereich einen Text enthält

 

 

Beste Grüße

Paul

best response confirmed by Paul_Wise (New Contributor)
Solution

@Paul_Wise 

Change the formula of the rule from

 

=$A$2="Druckansicht"

 

to

 

=UND($A$2="Druckansicht";B6<>"")

Thank you. Good job!