How can I assign a different color to a column in a split form?

[Pack10]

I am working with a split form. One of my columns is "Assigned To". When the form is displayed, I would like each person in the assigned to have their own color ...
I know the columns have filter capability, but visually it would be good to see each item in its own color. How can I do that. Not sure where to assign the color.

 

[MajP]

If the form is continous you can only use conditional formatting, and you can only have 4 total conditions. You can not do this in code in a continous form. Changing one row will change all the rows.

 

[TheAceMan1]

How are ya Pack10 . . .

[blue]MajP[/blue] has given the reason why not, so how about a color that alternates between the default and some selection? ... this can be done.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]