Forum Discussion
HPreh
Oct 27, 2020Copper Contributor
Zellfarbe nach Datum
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 ...
Riny_van_Eekelen
Oct 28, 2020Platinum Contributor
HPreh You may use conditional formatting as demonstrated in the attached workbook.
- HPrehOct 28, 2020Copper Contributor
Riny_van_Eekelenthank you for your reply , but i can´t see how this works ??
- Riny_van_EekelenOct 28, 2020Platinum Contributor
HPrehOn the Home ribbon, look for the Conditional Formatting icon.
Click it and select "Manage Rules..."
Now, enter the rules as demonstrated in the next picture. Adapt the cell reference so that they apply to your real worksheet(s).
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:
- HPrehOct 28, 2020Copper Contributor
Riny_van_Eekelenthank you for your patience. i will try ad hopefully i get it ! thank you very much !!