+ Reply to Thread
Results 1 to 3 of 3

Have a row change co lour when criteria in cells are met.

  1. #1
    Registered User
    Join Date
    04-06-2013
    Location
    Australia Queensland
    MS-Off Ver
    Excel 2003
    Posts
    5

    Exclamation Have a row change co lour when criteria in cells are met.

    i all
    I was wondering if someone out there can help me, I have been trying to solve this for a while without success; Im sure this problem will be easy for some but unfortunately not for me .

    if Date in Column B:B is 300 days past the date nominated in the cell (=+B:B+"300") date is formatted in the cell as dd,mm,yyyy and A:A =yes, then that row changes to the colour to red.

    Can someone please help me with a formula?

    A:A B:B D:D E:E
    Current Received Case No. Overdue
    Yes 3/02/2013 ABC/13/00012 30/11/2013
    Yes 1/02/2012 ABC/12/00014 27/11/2012
    No 2/02/2012 ABC/12/00016 28/11/2012
    No 1/04/2013 ABC/13/00013 26/01/2014


    I have given a sample and E:E has been placed in only to show the calculation of B:B+300 days.

    Cheers
    Gatheringinfo
    Last edited by Gatheringinfo; 04-06-2013 at 06:50 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Have a row change co lour when criteria in cells are met.

    Conditional formatting in cell B1
    =B1>refdate + 300

    where "refdate" is the date your are referencing... Usually a cell value A1 or a named range as shown
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    04-06-2013
    Location
    Australia Queensland
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Have a row change co lour when criteria in cells are met.

    Hi

    Thanks for the quick response, sorry for being so slow still trying to drive this all new to me..
    Will give this ago; thanks heaps.

+ 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