Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: conditional formating dates

  1. #1
    New Member
    Join Date
    May 2013
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default conditional formating dates

    Hi to all
    I am trying to make a conditional formatting for dates.
    i want to highlight rows for a period of 10 days from the today() date and the input cell dates.
    if the cell in the date is out of this 10 days period it should change back to normal color.

    all the help will be appreciated.

    Akasha walker

  2. #2
    Board Regular
    Join Date
    Jan 2012
    Location
    CHENNAI , India
    Posts
    216
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: conditional formating dates

    Hi ,

    Give as much information as possible ; including worksheet cell / column / row references where ever possible.

    What is the range reference over which this Conditional Formatting is to be applied ?

    Will the value of 10 be specified in some worksheet cell , or can it be made a part of the CF formula ?

  3. #3
    New Member
    Join Date
    May 2013
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: conditional formating dates

    Hi Naray below is my example.

    A1
    date log Today date
    03-11-17 07-11-17
    05-11-17
    03-10-17 I just want to have marked
    20-11-17 dates 10 days less then today
    21-11-17
    25-10-17 28-10-17 =today()-10
    19-10-17 so just the dates between today and 28-10-2017
    16-11-17 should be highlighted.
    26-11-17
    28-11-17
    12-10-17
    14-11-17
    20-11-17

    akasha walker

  4. #4
    Board Regular
    Join Date
    Jan 2012
    Location
    CHENNAI , India
    Posts
    216
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: conditional formating dates

    Hi ,

    Suppose your data is in the range A2:A14 ; select this range , and in the Conditional Formatting formula box enter the formula :

    =AND($A2 >= TODAY() - 10, $A2 <= TODAY())

    Adjust the >= , <= signs to > , < in case you do not want this.

    What this will do is , for the data you have posted , is colour the first two entries of November 3 and November 5.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

DMCA.com