conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
I've tried some of your solutions about Conditional Formatting, but none of
them worked with me. I have a Combobox with 2 columns:
"1";"Minor"
"2";"Major"
The first column is the bound column. When I chose the value "2", I want
that the value that apears in the column ("Major") have a diferent font color
result.
The Conditional Formatting doesn't be clear in witch column the condition is
applied.
Someone help me?
 
Nuno said:
I've tried some of your solutions about Conditional Formatting, but none of
them worked with me. I have a Combobox with 2 columns:
"1";"Minor"
"2";"Major"
The first column is the bound column. When I chose the value "2", I want
that the value that apears in the column ("Major") have a diferent font color
result.
The Conditional Formatting doesn't be clear in witch column the condition is
applied.
Click to expand...


A combo box's color properties apply to the text portion of
the control. The text portion of a combo box only displays
the column with the first non-zero ColumnWidth.

You can not affect the color in the drop down list.

Typically, you would set the ColumnWidths to 0; to hide the
first column in the drop down list, Then the text portion
would display either Major or Minor. You can use
Conditional Formatting to display this in different colors
by using the Value Is 2
 
Back
Top