+ Reply to Thread
Results 1 to 2 of 2

Datum in excel kleuren

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    Groningen
    MS-Off Ver
    2013
    Posts
    1

    Datum in excel kleuren

    Hallo,

    Ik zit met het volgende. In kolom O en Kolom N voer ik handmatig een datum in. Nu wil ik graag dat de cel in kolom N rood kleurt als de datum in Kolom O verder dan 3 maanden is (zowel negatief als positief). Kortom de datum in kolom O mag dus 3 maanden voor en 3 maanden na de datum in kolom N zijn. Als de datum ouder is dan 3 maanden dan moet de cel in kolom N rood kleuren maar ook als de datum verder dan 3 maanden in de toekomst ligt. Ligt de datum van kolom N binnen de termijn van 3 maanden dan moet hij groen kleuren.

    Heeft iemand hier een oplossing voor ?

    Groet,
    André

  2. #2
    Forum Contributor
    Join Date
    05-27-2014
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    2007 & 2010
    Posts
    273

    Re: Datum in excel kleuren

    This can be accomplished using conditional formatting:

    There's two rules:

    1: Red when the value in Column N is less than OR greater than 3 months of the date in column O:
    Conditional formatting 3.png

    2: Green when the value in Column N is greater than or equal to AND less than or equal to 3 months of the date in column O:
    Conditional formatting 2.png

    Make sure that both rules apply to the whole of column N:
    Conditional formatting 1.png

    This way the fonts will be red or green only when there is a date. When there is something other than a date (like the title of the column) then the font colour won't be affected by the conditional formatting.

    You can copy the rules here:
    Please Login or Register  to view this content.
    I used Google translate to translate your post so apologies if I've misunderstood your question.
    Last edited by kadeo; 10-14-2015 at 09:45 AM.
    Please click *Add Reputation if I've helped

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 06-12-2014, 01:51 PM
  2. [SOLVED] Evaluating single datum arrays
    By menim in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-02-2014, 06:31 AM
  3. Defining a datum for a stacked bar chart
    By Christian411 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2008, 07:21 AM
  4. Replies: 3
    Last Post: 03-20-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1