+ Reply to Thread
Results 1 to 3 of 3

Conditional format rows with differing dates

  1. #1
    Registered User
    Join Date
    02-19-2004
    Posts
    57

    Question Conditional format rows with differing dates

    Hi,

    I would like to colour rows based on the dates. As long as its a new date, it will be a different colour from the previous date.
    I can't do it based on even or odd dates in the month as not all dates will be included in the range... pls see the attached file...

    Hope someone out there has some clue on how to achieve this!

    Any help will be greatly appreciated.

    Wishing all a very HAPPY NEW YEAR!!!
    Attached Images Attached Images

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Assuming your dates are in column A try this:

    Select column A

    Apply conditional formatting with "formula is" option and the formula

    =MOD(COUNT(1/FREQUENCY(A$1:A1,A$1:A1)),2)*ISNUMBER(A1)

    select format as required

    OK

  3. #3
    Registered User
    Join Date
    02-19-2004
    Posts
    57
    it works like magic!
    thanks so much!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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