RHurlburt
03-01-2005, 09:37 AM
I have attached an example sheet of what I would like to do. Basically, there are two problems.
First:
I have negative and positive results that I would like to portray as block arrows up, or down, using Number Custom Format, in a cell next to the result. In the example attached, I have been able to display two different symbols in this manner, but not the "block arrows".
Second:
I would also like to display a round circle in red, green or yellow (like a traffic signal) which would depend on criteria established by a formula ... ie, if I have 3 criteria and all three are positve, the result is a "green light". If two of the criteria are positive and one negative, the result is a "yellow light". If one or none of the criteria result in negatives, the result is a "red light".
Although it would be simpler to use Number Custom Format, I suspect my only answer is VBA.
Any thoughts?
Thanks!!
Richard
First:
I have negative and positive results that I would like to portray as block arrows up, or down, using Number Custom Format, in a cell next to the result. In the example attached, I have been able to display two different symbols in this manner, but not the "block arrows".
Second:
I would also like to display a round circle in red, green or yellow (like a traffic signal) which would depend on criteria established by a formula ... ie, if I have 3 criteria and all three are positve, the result is a "green light". If two of the criteria are positive and one negative, the result is a "yellow light". If one or none of the criteria result in negatives, the result is a "red light".
Although it would be simpler to use Number Custom Format, I suspect my only answer is VBA.
Any thoughts?
Thanks!!
Richard