Cobditional Formatting Rows based on dates in action plan.

[Lillian Livingston]

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