Hi,

Am not sure if this is possible with Checkbox created using Forms
toolbar, but i have got a workaround.

Enter the following simple formula in the cell (Say B1) , where you want
the Checkbox :

=IF(A10,"a","") where A1 is the cell which has got the positive or
negative number.

And then format the cell B1 to the Font called 'Marlett'.

Now, when A1 is more than 0, B1 will return 'a'. The alphabet 'a' is
shown as a checkbox in the Marlett Font and hence you would see a
checkbox. If A1 is less than 0, the formula returns a blank and it would
appear as a blank in Marlett Font also.

Regards

Govind.


C. Cunningham wrote:

Is it possible to have the checkbox value (either checked or unchecked)
dependent on if the number in another cell is positive or negative (greater
than or less than zero)?

I've tried the "cell link" option on the "control" tab of the format control
popup menu, but it doesn't return what I want. It seems to do the opposite.
It takes the value of the checkbox and returns a true or false in the linked
cell. Is there a way to reverse it?

I'm using this on an expense voucher form and the checkbox indicates if the
final balance due (after deducting any advanced monies) is payable to the
company (negative balance) or payable to the employee (positive balance).

Any help is appreciated. Using Excel 2002 with Windows XP Professional.