I am having issues trying to color code a drop down select list
I am using Apex 4.2 and the group Calendar application page 1
I have a table that has both a field for the color code and the data for the select list so I am trying the following code in the lov definition
<tt>
select group_name d, group_name r,
case when display_color is not null
then 'color:' || et.display_color || '; font-weight:bold;'
else 'font-weight:bold;'
end span_class
from eba_ca_email_groups et
order by 1
</tt>
and I get an error about the lov list "Wrong number of columns selected in the LOV SQL query..."
What am I doing wrong I want the select list to look like the text in the legend shown below (or if the entire row is highlighted with the appropriate color that is okay too as opposed to only the text)
Thanks