asked on

Conditional formatting chart to track mailing and responses

Hi Experts excel 2007

I am look to find a way to track how long it takes a customer to response to a mailed letter from the date of posting...

So If the letter was posted today and return back in 7 days time.....
Then using conditional formatting
1. 0-5 days green
2. 5-10 days amber
3. > 11 days going red

so
A1. B1. C1. D1
Date. Date. Number of days. Chart
Sent. Return.

1 jan. 12 jan. 11. Here chart going from green to Amber as the number of days passes..

Steven Harris

Is this what you have in mind?

In cell D2, setup the following conditional formulas (start with bottom rule, then add the next one above...):

Once applied, copy the cell down to the remaining cells.

You can also apply to the Number of days themselves:

I have attached an example sheet with both options. Select a set of data (C2:C6 or D2:D6) and then go to Home tab > Style group > Conditional Formatting > Manage Rules to view what has been applied.

If this is not what you had in mind, let me know.
cond-formatting.xlsx

route217

ASKER

Looks great...is it possible to have lines vertical for each day...

ASKER CERTIFIED SOLUTION

Steven Harris

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

route217

ASKER

Fantastic ......100ercent...