I have excel 2007 (sorry for the previous post)
I have a table like this

Start Date Duration Staff Staff 2
JOB 1 5/1/2009 29 Bob Dan
JOB 2 5/1/2009 60 Jeff Denise
JOB 3 5/15/2009 61 Ben Dan
JOB 4 5/15/2009 61 Jeff Paul

I would like to be able to have different colors for each person.
Only want each job listed once on the left.
possible?

Hi,

Are you trying to create a gantt chart or do you just want to color each row
a different color.

Check out the topic Gantt Charts at Jon's site:

http://peltiertech.com/Excel/Charts/ChartIndex.html#G

If you only want to color each row a different color in the spreadsheet get
back to us.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"KKay" wrote:

I have excel 2007 (sorry for the previous post)
I have a table like this

Start Date Duration Staff Staff 2
JOB 1 5/1/2009 29 Bob Dan
JOB 2 5/1/2009 60 Jeff Denise
JOB 3 5/15/2009 61 Ben Dan
JOB 4 5/15/2009 61 Jeff Paul

I would like to be able to have different colors for each person.
Only want each job listed once on the left.
possible?