Zellfarbe nach Datum

%3CLINGO-SUB%20id%3D%22lingo-sub-1826189%22%20slang%3D%22de-DE%22%3ECell%20color%20by%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1826189%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20change%20of%20cell%20color%20by%20date%20entry%20in%20the%20cell.%20So%20-%20no%20date%20set%20%3Dred%2C%20date%20in%20future%20%3D%20yellow%2C%20date%20past%3D%20green.%20it%20is%20an%20overview%20of%20booked%20or%20performed%20courses.%20I%20hope%20I%20was%20able%20to%20express%20myself%20in%20a%20comprehensible%20way%20and%20hope%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1826189%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1826233%22%20slang%3D%22en-US%22%3ERe%3A%20Zellfarbe%20nach%20Datum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1826233%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3Ethank%20you%20for%20your%20reply%20%2C%20but%20i%20can%C2%B4t%20see%20how%20this%20works%20%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1826264%22%20slang%3D%22en-US%22%3ERe%3A%20Zellfarbe%20nach%20Datum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1826264%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F848442%22%20target%3D%22_blank%22%3E%40HPreh%3C%2FA%3EOn%20the%20Home%20ribbon%2C%20look%20for%20the%20Conditional%20Formatting%20icon.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-10-28%20at%2008.30.32.png%22%20style%3D%22width%3A%2075px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229761i5455C26251D1E03F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-10-28%20at%2008.30.32.png%22%20alt%3D%22Screenshot%202020-10-28%20at%2008.30.32.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EClick%20it%20and%20select%20%22Manage%20Rules...%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-10-28%20at%2008.30.47.png%22%20style%3D%22width%3A%20233px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229762iA0E4A5199D157118%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-10-28%20at%2008.30.47.png%22%20alt%3D%22Screenshot%202020-10-28%20at%2008.30.47.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENow%2C%20enter%20the%20rules%20as%20demonstrated%20in%20the%20next%20picture.%20Adapt%20the%20cell%20reference%20so%20that%20they%20apply%20to%20your%20real%20worksheet(s).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-10-28%20at%2008.31.05.png%22%20style%3D%22width%3A%20709px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229763i48B047051A9E7F9D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-10-28%20at%2008.31.05.png%22%20alt%3D%22Screenshot%202020-10-28%20at%2008.31.05.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%2C%20the%20above%20pictures%20are%20taken%20from%20the%20Excel%20for%20Mac%20version%2C%20but%20it's%20similar%20for%20the%20PC%20versions.%3C%2FP%3E%3CP%3EYou%20can%20read%20all%20about%20it%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

hallo an alle !

 

ich brauche eine Änderung der zellfarbe nach Datumseintrag in die Zelle. Also - kein Datum gesetzt =rot, datum in zukunft = gelb, datum vergangen= grün. es geht um eine Übersicht gebuchter oder geleisteter Kurse. ich hoffe ich konnte mich verständlich ausdrücken und hoffe auf eure Hilfe.

4 Replies
Highlighted

@HPreh You may use conditional formatting as demonstrated in the attached workbook.

 

Highlighted

@Riny_van_Eekelenthank you for your reply , but i can´t see how this works ??

Highlighted

@HPrehOn the Home ribbon, look for the Conditional Formatting icon.

Screenshot 2020-10-28 at 08.30.32.png

Click it and select "Manage Rules..."

 

Screenshot 2020-10-28 at 08.30.47.png

Now, enter the rules as demonstrated in the next picture. Adapt the cell reference so that they apply to your real worksheet(s).

 

Screenshot 2020-10-28 at 08.31.05.png

 

Note, the above pictures are taken from the Excel for Mac version, but it's similar for the PC versions.

You can read all about it here:

https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60... 

Highlighted

@Riny_van_Eekelenthank you for your patience. i will try ad hopefully i get it ! thank you very much !!