Bedingte Formatierung mehrerer Zellen

%3CLINGO-SUB%20id%3D%22lingo-sub-2418153%22%20slang%3D%22de-DE%22%3EConditional%20formatting%20of%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2418153%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3Efor.B%20example%2C%20if%20there%20is%20a%20certain%20text%20in%20cell%20B2%2C%20I%20want%20to%20format%20cells%20A2%20to%20G2%20in%20one%20color.%3C%2FP%3E%3CP%3EThe%20whole%20thing%20should%20apply%20to%20the%20entire%20table%2C%20depending%20on%20the%20text%20in%20column%20B%3F.%3C%2FP%3E%3CP%3EOther%20text%20in%20column%20B%3F%20means%20a%20different%20formatting.%3C%2FP%3E%3CP%3EIt%20would%20be%20best%20if%20you%20could%20take%20the%20formatting%20from%20a%20separately%20created%20table%20in%20which%20the%20keywords%20are%20listed%20in%20the%20appropriate%20formatting.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eregards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2418153%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2418293%22%20slang%3D%22en-US%22%3ERE%3A%20Bedingte%20Formatierung%20mehrerer%20Zellen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2418293%22%20slang%3D%22en-US%22%3ECheck%20out%20conditional%20formatting.%20It%20will%20do%20what%20you%20want%20-%20use%20a%20'custom%20formula'%20for%20the%20criterion%20for%20each%20color%2Fformat.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hallo,

ich möchte, wenn z.B. in Zelle B2 ein bestimmter Text steht, die Zellen A2 bis G2 in einer Farbe formatieren.

Das Ganze soll für die gesamte Tabelle gelten, in Abhängigkeit des Textes in der Spalte B?.

Anderer Text in Spalte B? bedeutet eine andere Formatierung.

Am besten wäre, wenn man die Formatierung aus einer separat erstellten Tabelle übernehmen könnte, in der die Schlüsselwörter in der entsprechenden Formatierung gelistet sind. 

Wie kriege ich das hin?

 

Viele Grüße

 

2 Replies
Check out conditional formatting. It will do what you want - use a 'custom formula' for the criterion for each color/format.

@Shamane-7 

Here is an example file with various conditional formatting options.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

Please Mark and Vote this reply if it helps, as it will be beneficial to more Community members reading here.