AnsweredAssumed Answered

Assigning a color to value list item?

Question asked by DanielPinder on Jan 28, 2011
Latest reply on Feb 27, 2011 by DanielPinder


Assigning a color to value list item?


Hi There,

I have three fields all of which are pop-up menus drawing from the same value list. The reason there are three is to be able to assign up to three keywords to the record. I have assigned conditional formatting to each of the fields:

if (table::themes1 = "Romance" ; 1 ; 0)

But I have to re-enter everything three times. in addition, I have to choose the same color patch for the corresponding value list items each time. 

Is there a better way to do this? Ideally, I would be able to assign each keyword a color in a global fashion, perhaps in a kind of "preferences" layout, the way I do for other global things.