Cobditional Formatting Rows based on dates in action plan.

Jul 18, 2016
Reaction score
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.


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. After that, you can post your question and our members will help you out.

Ask a Question