Making the forms scroll bar show - figures.

[Guest]

Hi,

I am using the forms scroll bar and linking it to a cell to change a number
which i am using as an adjustable varible to base conditional formatting on.
ie if cell invoice amount is greater than the variable cell show in the
colour red. It works for figures over the amount but i also want a seperate
one to show cell invoice amounts that are - the variable ie invoice less than
100 say. However if you go to format control and change the minimum value to
- 1000 it says the values must be within 0 and 3000. Does anyone know a way
aropund this? or shoud i be using the scroll bar on the control toolbox
instead.

 

[vezerid]

Hi,

I am using the forms scroll bar and linking it to a cell to change a number
which i am using as an adjustable varible to base conditional formatting on.
ie if cell invoice amount is greater than the variable cell show in the
colour red. It works for figures over the amount but i also want a seperate
one to show cell invoice amounts that are - the variable ie invoice less than
100 say. However if you go to format control and change the minimum value to
- 1000 it says the values must be within 0 and 3000. Does anyone know a way
aropund this? or shoud i be using the scroll bar on the control toolbox
instead.

Let us say you want to get values from -1000 to 3000. You make the
scrollbar get values from 0 to 4000, you link it to another cell, say
A2, and then you make the cell of interest get the values that you
want with the formula:

=A2-1000

HTH
Kostis Vezerides

 

[Guest]

Thanks Vezerid ;-)

Let us say you want to get values from -1000 to 3000. You make the
scrollbar get values from 0 to 4000, you link it to another cell, say
A2, and then you make the cell of interest get the values that you
want with the formula:

=A2-1000

HTH
Kostis Vezerides