Forum Discussion

Copper Contributor

Oct 27, 2020

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

excel

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Oct 28, 2020

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

hpreh.xlsx9 KB

HPreh
Copper Contributor
Oct 28, 2020
Riny_van_Eekelenthank you for your reply , but i can´t see how this works ??
- Riny_van_Eekelen
  Platinum Contributor
  Oct 28, 2020
  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:
  https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
  - HPreh
    Copper Contributor
    Oct 28, 2020
    Riny_van_Eekelenthank you for your patience. i will try ad hopefully i get it ! thank you very much !!