Cobditional Formatting Rows based on dates in action plan.


Joined
Jul 18, 2016
Messages
1
Reaction score
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
 
Ad

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

Ask a Question

Similar Threads


Top