+ Reply to Thread
Results 1 to 2 of 2

Conditional Shape of an arrow based on cell value

  1. #1
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Conditional Shape of an arrow based on cell value

    Hi crew,

    I can almost hear you guys telling me that changing the direction in which an arrow on my worksheet based on whether, say, A1>A2, can only be done with code. But is worth a try to ask whether we can do it some other way. I searched, but all of them as asking to change the colour of an autoshape or make it disappear, and stuff like that, and on all of them code was recommended. Would that be for my case as well?

    Thanks pals,
    Last edited by ron2k_1; 06-30-2010 at 09:00 PM.
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Conditional Shape of an arrow based on cell value

    For sure, it is worth a try, unfortunately...

    This can only be done with code.
    This example is a protected sheet so that only one cell can be changed.
    Change the Number and the line will change.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1