exporting data to excel

C

chris

In project I'm using a status field with graphical indicators (red, green etc) to indicate status. I'm exporting this data to excel. In excel the field is represented by the numerical value of the indicator (0,1,2,3). Are the same graphical indicators (red, green circles) available in excel as well. I saw the conditional formating which allowed color to be added to text but could not find similar graphical indicators as in project. Can anyone tell me how to get the same effect in the exported excel data?
Thanks
 
J

JackD

Conditional formatting is the closest you are going to get in excel unless
you write some special code.

-Jack

chris said:
In project I'm using a status field with graphical indicators (red, green
Click to expand...
etc) to indicate status. I'm exporting this data to excel. In excel the
field is represented by the numerical value of the indicator (0,1,2,3). Are
the same graphical indicators (red, green circles) available in excel as
well. I saw the conditional formating which allowed color to be added to
text but could not find similar graphical indicators as in project. Can
anyone tell me how to get the same effect in the exported excel data?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graphical indicators 2
Graphical Indicators on Resource Assignment Rows 5
Project Stand-Alone Graphical Indicators (Red, Yellow, ....) 2
Problem with the RAG Status in Project 0
Newly created Enterprise Project Fields do not appear correctly in 3
Deletiing Graphical Indicators with VBA 2
Indicator to show task approaching end date 2
custom field does not properly show in PWA 1

Top