Hi guys:

This should be quick! What I'd like to do is calculate in cell C40 to
resulting value of say 9.5% of the amount in cell C6, which is 15,000. But,
I'd also like not to have a zero value show-up in the target cell if there is
no value in cell C6. The percentage value is listed in cell B40. When this
percentage value in cell B40 changes, the result in cell C40 should reflect
that change. If it becomes a negative value, have it show-up in RED. Is this
possible?

Thanks,