I would like in a project plan add text to highlight cells

[larvidss]

Hi !

I would like in a project plan be able to highlight cell from start and stop date plus decide a text in each cell that is high light.
See below how I would like it to work
I have attached excel sheet where Task 1 and Task 2 is green highlight and task 3 blue marked.

I would like to add text to the cells that is highlight from cell D so it copy out my resource name in the highlight cells

Is it possible if Yes can some one help me ?

Task Start End Resourse 2011-04-01 2011-04-02 2011-04-03
Task1 2011-04-01 2011-04-03 Daryl Daryl Daryl Daryl
Task2 2011-04-02 2011-04-03 Daryl Daryl
Task5 2011-04-01 2011-04-03 Lars Lars Lars Lars

Br
Lars-Erik

[dredwolf]

See if this will work for you (I am using the sample, so ranges would need to be changed for actual data)
In E2:

=IF(AND(E$1>=$B2,E$1<=$C2),$D2,"")

Drag down and across (see attached)

(NOTE- the formulas will work, even if the workbook comes up with 'significant loss..' error...it looks like you saved a 2007+ workbook in 2003- mode, the error shows as a 'conditional formatting' issue, which I have not touched)

Hope this helps

[larvidss]

Hi !

Thanks foy your help
The excel sheet you attached is working as I wanted.

I wonder if you know if it possible to use conditional Formatting to highlight the color and include the text you want for the cells ?
I have done some minor changes in the excel sheet and in row 13 to 16 you can see how I would like the text to be including conditional Formatting below and text

If it’s possible to have all recourses in raw4 and with color and text who is working on the task1 ?

1. Green Raw14
=AND(COUNT($B14:$C14)=2;E$13>=$B14;E$13<=$C14) Can I use formula to include a text here in conditional Formatting ?

2. Red Raw15
=AND(COUNT($B15:$C15)=2;E$13>=$B15;E$13<=$C15)

3. Blue Raw16
=AND(COUNT($B16:$C16)=2;E$13>=$B16;E$13<=$C16)

Br
Lars-Erik

[dredwolf]

See if this is close to what you want, your changes are inconsitent and very confusing, so I went with a single formula that changes references as needed..
(Using attached)
in E26:

=IF(AND(E$25>=$B26,E$25<=$C26),$D14,E27)

Drag down and across

Note- I have left your CF rules alone, as they seem to give what you want

Hope this helps

[larvidss]

Hi !

Thanks foy your help and sorry for my late respond to your help.

I have attached my excel sheet with changes build on your advice.
Please have a look at my excel sheet and I hope it clarify what I mean.

In two lines can I now overview the two projects that is ongoing and when each resource is allocated for which date in the Project

Br
Lars-Erik