Zellfarbe nach Datum

Copper 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

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

 

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

@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... 

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