Hi,
I need help with starting off a macro, and hope someone can help. I'll try
and briefly describe what I am trying to achieve. The w/s below represents a
very simple project progress track for weekly presentation purposes. Each
project will be represented by a single line entry. One field will be
'Status' which can be: Green, Amber, Red, Blue or Yellow. The next field will
be 'Trend' which can be +, -, or =.

So, if I could get help developing the following I think I may be able to
have a go at the rest.Given w/s Project with columns A to E:

1. if 'g' (for Green) is input into any cell (X) in column D (Status)then:
- cell is 'filled' with color green,
- Color of any text input to E(X) is colored green,
2. Is there any way to track previous entry in D(X) such that if previous
entry in D(X) was 'g', while current status is 'g', then trend '=' is shown
in green color. However, if previous status was 'r' and current status is 'r'
then trend '=' is shown in red color.

Thx,

Don-