Hi,

to be honest, I haven't played around much on this yet, but I'm wondering:

Is there a way/formular to automatically fill 1 cell of a custom with a value based on a condition?

i.e.
I have custom field "Color" which uses a Lookup (Red, Amber, Green as valid values).
Now I would like the summary task to automatically set the color based on the values in the subtasks (Green if all green, amber if at least 1 subtask is amber or red if at least 1 subtask is red).

How would I do this?

Thanks in advance

Sorry - no. You could change the color of the bar by using a Flag field but background color is not accessible through custom fields.

Actually it's text instead of actual field colors. Missed to point that out.
Does that make a difference?

No, it really doesn't. The Text Styles command is limited and doesn't allow creation of new styles. If you have some VBA skills, see the following post for some sample code to change text colors. And actually, I think this code does change background color

https://social.msdn.microsoft.com/Fo...ct2010custprog

And here's another link:

http://www.techrepublic.com/article/...in-ms-project/

Alright, I will give this a shot. Thank you!

You're welcome. Let us know how you get along.