On Mon, 01 Apr 2013 10:37:41 -0400, GS wrote:

Well.., I think the CF might be easier to manage if you handled it via
a userform, where you could implement a color picker. You could assign
a name for each new program added, and set the CF for it by code.

I was more along the lines of polling the planner to select the color
from a set list. From there forward, the work order selection will
define "PrgClr". Then, I only need the number of CFs that match my
defined set of available colors. Via formula as:

=PrgClr="TAN"
or (and)
=PrgClr="GLD"
or
=PrgClr="YEL"
or
=PrgClr="BLU"

Etc.


And set the formatting for each of those criterion elements.

Currrently, I have to set one up for each newly added "program".

Way more CF rule entries. This way, I only need to define the number of
CFs that match my closed set of available colors, and make the "program"
name include their assigned color in that row of data entries.


Have you tried Jan Karel Pieterse's "Name Manager" addin?

Not as yet.

www.jkp-ads.com

Thanks, bud.