sing2trees1983
New Member
- Joined
- Feb 3, 2006
- Messages
- 26
Hi all,
Hope someone can help me here.
I have a spreadsheet with the following column headers:
A Task
B Owner
C Start date
D End date
E Completion
F 1st Nov
G 2nd Nov
H 3rd Nov (etc)
What I would like is that if I enter a task in A, owner and the due start/end date then the relevant date range (col F onwards) would change colour from white to orange for example.
Then when a completion date is entered, the whole row turns green.
Is this possible and if so, can anyone help with the formula?
Many thanks in advance!
Hope someone can help me here.
I have a spreadsheet with the following column headers:
A Task
B Owner
C Start date
D End date
E Completion
F 1st Nov
G 2nd Nov
H 3rd Nov (etc)
What I would like is that if I enter a task in A, owner and the due start/end date then the relevant date range (col F onwards) would change colour from white to orange for example.
Then when a completion date is entered, the whole row turns green.
Is this possible and if so, can anyone help with the formula?
Many thanks in advance!