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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. bookerk2

    help with conditional formatting

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

    sum based on value in a range

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

    Conditional Formatting Formula

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

    Text to Rows

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