• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Arrow effect using formulas - is such thing possible?

PP3321

Active Member
Rather than using AutoShape, I want to enter arrows as formulas within the cell
Please find the attached image.

Rather than using image, I want to create this arrow effect by entering words.
I know I can type arrow sign like this ↓

I am looking for round arrow...
Is it possible...?
 

Attachments

  • Increase.png
    Increase.png
    3 KB · Views: 17
There is no native way to do that

You can do something similar using the Wing Ding fonts
upload_2016-4-24_21-38-21.png

B2: =IF(B2<B3,"",":")
B3: =IF(B3<B2,"","8")

Then set the Font on B2 & B3 to Wingdings3

To fully replicate what you want you could use shapes and some VBA to turn the shapes visibility on/off as the cell values change
 
Wow thank you so much! I totally forgot about Windings Fonts.
At the moment VBA is out of scope, as this excel sheet has to be used for other applications, which would not accept macro-enabled worksheets.
You guys are awesome! Thank you!!
 
Back
Top