why does conditional formatting 'work'

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

Guest

hi --

i have a combobox on my switchboard screen in my a2k app'n. it's got a
litany of numbers ranging from
0,1,2,3,4,.....,99,100,105,110,115,....,195,200 like this.

the default colors are black on white b'ground. i'd like to alter them
subject to the condition that yellow's on green b'ground when value is 0;
black is on yellow b'ground when value is between 1 and 99. lastly, when
value's greater than 99 i'd like them to have yellow on red b'ground.

the first two condtions are being met during my testing of this. here's the
clinker though....the 2nd condition persists even though i select values
exceeding 99??!!!!

anybody know what gives and how to solve?

-ted
 
hi --

i have a combobox on my switchboard screen in my a2k app'n. it's got a
litany of numbers ranging from
0,1,2,3,4,.....,99,100,105,110,115,....,195,200 like this.

the default colors are black on white b'ground. i'd like to alter them
subject to the condition that yellow's on green b'ground when value is 0;
black is on yellow b'ground when value is between 1 and 99. lastly, when
value's greater than 99 i'd like them to have yellow on red b'ground.

the first two condtions are being met during my testing of this. here's the
clinker though....the 2nd condition persists even though i select values
exceeding 99??!!!!

anybody know what gives and how to solve?
Click to expand...

My guess is that it's treating the combo box value as Text rather than
as a number - as a text string "99" sorts after the text string "100".

Try using Val() to convert the text string to a number in the
Expression in the conditional formatting window.

John W. Vinson[MVP]
 
Back
Top