Cobditional Formatting Rows based on dates in action plan.

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

  1. Lillian Livingston

    Lillian Livingston

    Jul 18, 2016
    Likes Received:
    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.

    Lillian Livingston, Jul 18, 2016
    1. Advertisements

Ask a Question

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.