Hi,

this might be trivial, but is nagging me quite a lot. I have a project master list with timelines (that are colored cells) in one sheet. In the other sheet (W2) i have the projects sorted as per priority (using a formula). I want that in W2, depending on the Project title, i should be able to pick up the cell color (timelines) as well. Can anyone suggest how this can be done?

Regards

Gurpreet