Excel Formula Help

In Progress Posted Mar 12, 2012 Paid on delivery
In Progress Paid on delivery

I use Excel to manage a small project. I have a very small piece of work as follows.

I need Excel forumula that will do the following:

1. In my Task row examine cells with dates in them titled "Start Date" and "End Date" and then indicate in a "Status" cell whether the task is "In progress" (ie the "End Date" is greater than today) or "Overdue" if the "End Date is equal to or less than Today.

2. If the "Start Date" is later than today then write "Not Started" in the "Status" cell.

3. If the Status is "In Progress" then colour the Status cell green, f "Overdue" colour the Status cell red, and if "Not Started" colour the cell blue.

Excel

Project ID: #1498485

About the project

56 proposals Remote project Active Mar 14, 2012

Awarded to:

jburnsep

MASUDMYMEN, **MODIFIED** I HAVE MULTIPLE REVIEWS WITH FEEDBACK ,JUST NOT IN THIS CATEGORY...I ALSO HAVE WON A FREELANCER CONTEST. Your request is very standard (but I have some improvement suggestions), my deve More

$500 AUD in 1 day
(0 Reviews)
0.0

56 freelancers are bidding on average $551 for this job

caabdul

Sir, I can do it, details in PM

$500 AUD in 1 day
(48 Reviews)
6.1
MDavidCrompton

Hi, The job is done, see PM. Also please check my feedback. I cannot expect $500 for so little work but the system will not let me bid less than minimum. Make me an offer!!! Regards David

$500 AUD in 1 day
(32 Reviews)
5.0
esalem

Hello, please see the PM for details.

$500 AUD in 5 days
(12 Reviews)
5.1
kulhanekd

I can assist in your project. see PM Thanks Donna

$500 AUD in 5 days
(10 Reviews)
4.3
FLtowhid

Please see my PM.

$500 AUD in 3 days
(4 Reviews)
3.8
dguest

Hi. I can start this for you immediately. Please see my PM.

$500 AUD in 3 days
(3 Reviews)
3.0
freshjah

I can do this for you and can start immediately.

$500 AUD in 1 day
(3 Reviews)
2.0
saranga86

Please see the PM.

$500 AUD in 2 days
(1 Review)
1.0
balabeena

I can help you with this.

$500 AUD in 1 day
(2 Reviews)
1.0
a2avin

I am an excel expert and have worked on multiple full time projects in excel. I have worked for world's esteemed organisation. Will finish your work in time. Look my profile for more details.

$500 AUD in 1 day
(0 Reviews)
0.0
Dewnoz

I have 5 years experience in data entry especially working with excel and I will do a perfect job in 3 days.

$500 AUD in 3 days
(0 Reviews)
0.0
zadim

hi i am interested to do this work

$500 AUD in 1 day
(0 Reviews)
0.0
krnmadake04

hello i had a lot of knowlage of formula's in exel i had worked for maintaining exel for 2years so plz award me this project waiting for your reply

$700 AUD in 14 days
(0 Reviews)
0.0
seagate2012

I am a novice but I'm a hard worker and I was able and capable of performing this task. self-motivated and eager to move forward

$500 AUD in 3 days
(0 Reviews)
0.0
professional3302

########### Excel Professional with 7 Years of Experience ###########

$500 AUD in 1 day
(0 Reviews)
0.0
mielu

Ready to start !

$550 AUD in 1 day
(0 Reviews)
0.0
f3solutions

quite a interesting job!!! Waiting for Ur confirmation!!!

$520 AUD in 5 days
(0 Reviews)
0.0
welikumbura

Nice doing business with you.

$519 AUD in 3 days
(0 Reviews)
0.0
vaishnavk5

I can do this work.

$500 AUD in 10 days
(0 Reviews)
0.0
anandkedari

I can do this and deliver it today itself. Please see your inbox.

$500 AUD in 0 days
(0 Reviews)
0.0