Preserve Conditional Fill Colors When Pasting from Excel to Microsoft Project
Question details
The user needs to keep conditional fill colors from an Excel or Google Sheets status column when pasting values into Microsoft Project, so statuses such as Blocked and On Track keep their corresponding colors.
- Product
- Microsoft Project and Microsoft Excel / Google Sheets
- Device & OS
- not provided
- Scenario
- The user copies a status column that uses conditional formatting or data-validation colors from Excel or Google Sheets and pastes the values into Microsoft Project.
- Observed behavior
- The conditional fill colors are lost when the values are pasted into Microsoft Project; only the text is retained.
Make a note of the exact status values and their fill colors from the source sheet. In Microsoft Project, confirm that the target field is visible in the Gantt Chart or task sheet where you want the colored indicators.
Recreate Status Colors in Microsoft Project with a Custom Field and Graphical Indicators
Use this when you need to keep Blocked/On Track-style colors inside Microsoft Project, because Project does not inherit spreadsheet conditional formatting when you paste.
Microsoft Project stores formatting in its own fields and view settings. It cannot read spreadsheet conditional formatting, but you can map a text value to a fill color by using a custom text field and graphical indicators.
In Microsoft Project, open Project > Custom Fields, choose a Text field such as Text1, rename it to Status, and click OK.
Select the target task column, then paste or type the status values such as Blocked, On Track, and At Risk into the custom field.
Go to Project > Custom Fields again, select the Status field, and click Graphical Indicators.
For each test value, such as equals Blocked, choose red; for equals On Track, choose green. Click OK and apply the setting to the current view.
Keep Conditional Fill Colors in WPS Spreadsheets Instead of Pasting into Project
Use this if you want to share or update the status sheet as an Excel file and keep the Blocked/On Track colors, dropdowns, and data validation intact.
Use WPS Office to Keep Spreadsheet Status Colors Without Microsoft Project
Microsoft Project does not preserve Excel conditional formatting when you paste. If you routinely need spreadsheet status colors and dropdown behavior, WPS Office is a free, lightweight alternative that keeps Excel formatting, data validation, and familiar workflows without requiring Microsoft Project.
- 1. Download WPS Office: Go to wps.com and click Download WPS Office Free, then install it on your Windows or Mac device.
- 2. Open the Excel status file in WPS Spreadsheets: Launch WPS Office, click Sheets, and open the .xlsx source file that contains the conditional fill colors.
- 3. Review conditional formatting and data validation: Select the status cells, click Home > Conditional Formatting > Manage Rules to verify that Blocked and On Track rules and colors are intact.
Frequently Asked Questions
Why do colors disappear when I paste from Excel into Microsoft Project?
Microsoft Project does not read Excel conditional formatting or data-validation fill colors. It only pastes the cell values as text, so you must recreate the color rules in Project.
How do I add Blocked/On Track colors in Microsoft Project?
Use Project > Custom Fields to create a text field, then open Graphical Indicators and map values such as Blocked to red and On Track to green.
Can WPS Office keep conditional formatting colors when I open an Excel file?
Yes. In WPS Spreadsheets, open the .xlsx file and use Home > Conditional Formatting > Manage Rules to see and keep the color rules.
Is WPS Office compatible with Microsoft Excel drop-down lists?
Yes. WPS Spreadsheets supports Excel data validation lists and .xlsx formatting, so existing dropdown and color rules usually remain intact.
