Results 1 to 3 of 3

Thread: shapes with formulas

  1. #1

    shapes with formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I was just wondering, is there a way to link a shape e.g. an arrow that changes according to the data?

    Would an if statement be used to say if a number goes above or below the previous number, then the arrow would point down or up or would this be a vb code?

    Many thanks.
    Attached Files Attached Files

  2. #2
    Good afternoon,

    I don't think the orientation of the arrow could be changed to "up" or "down" because, at least as far as I can tell/have knowledge of, VBA would interpret a rotation of x degrees rather than pointing up or down. You could accomplish something similar with conditional formatting: i.e. for cell e4 conditional formatting =if(d4>e4,1,0) and set formatting as a background of red then repeat for d4<e4 and d4=e4. Then the color of cell e4 would vary depending on the relation of it's value to the previous month. Just a thought.

  3. #3
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Try above suggestion using icons set and arrows up or down.

    Could use vba and on cell changed rotate or swap visibility of two shapes. However as much as I love programming I generally prefer a non van solution first. Otherwise need to ensure users have macros enabled etc. Simpler with standard options.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •