Need to default the Cost Column based on another column's value

[ProjectCalcs]

Hi everyone,
I am working with MS Project and have a custom text field populated with one of three values in that fiekl - Pre-Implementation, Implementation, or Post-Implementation. I need to automatically populate the cost column with either 1, 2, or 3, depending on teh selection in the custom text field. Is there a way to do this?

Alternatively, I could have the custom text field column automatically highlight the row or a value in the row, if the cost column is empty.



I don't know how to do either so any help would be appreciated!

[JulieS]

The cost field is calculated by Project and you cannot change that calculation. However, there are 10 spare cost fields that you can use to calculate a value.

Regarding the custom text field highlighting a row - not without code (VBA for example) to set the background color.