Cobditional Formatting Rows based on dates in action plan.

Discussion in 'Excel' started by Lillian Livingston, Jul 18, 2016.

  1. Lillian Livingston

    Lillian Livingston

    Joined:
    Jul 18, 2016
    Messages:
    1
    Likes Received:
    0
    Hi,
    I'm new to the forum and would be very grateful for some help to conditional format a action plan.

    The following columns are in my spreadsheet
    Column A: task activity
    Column B: due date
    Column C: completed date.

    What I would like to do is format the spreadsheet so if a task is overdue is highlighted in red the due date column b is highlighted in red.

    If the task due date is within 7 days the due date column B must be highlighted in orange.

    When the task completed date Column C is filled in it I want the row to be highlighted in green.

    Please help.

    Many thanks in advance.

    Lilly
     
    Lillian Livingston, Jul 18, 2016
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. bookerk2

    help with conditional formatting

    bookerk2, May 4, 2011, in forum: Excel
    Replies:
    1
    Views:
    781
    XLPadawan
    Jun 16, 2016
  2. DPCpresto
    Replies:
    0
    Views:
    302
    DPCpresto
    Apr 6, 2012
  3. baldi
    Replies:
    1
    Views:
    853
    Sohail
    Dec 25, 2014
  4. phdman
    Replies:
    1
    Views:
    536
    Kevin@Radstock
    Nov 2, 2012
  5. Siegfried

    sum based on value in a range

    Siegfried, Jun 27, 2014, in forum: Excel
    Replies:
    0
    Views:
    669
    Siegfried
    Jun 27, 2014
  6. teza2k06

    Conditional Formatting Formula

    teza2k06, Aug 23, 2014, in forum: Excel
    Replies:
    2
    Views:
    659
    XLPadawan
    Jun 16, 2016
  7. hyukfgh
    Replies:
    2
    Views:
    663
    hyukfgh
    Oct 16, 2014
  8. Jonny

    Text to Rows

    Jonny, Dec 16, 2014, in forum: Excel
    Replies:
    0
    Views:
    408
    Jonny
    Dec 16, 2014
Loading...