arrows

  1. U

    VBA to draw arrows between matching cells which change position

    I'm trying to create a VBA script that compares two similar ranges of cells and draws arrows between cells with matching text strings. Think of making a seating chart of names in excel where you want to visually show the necessary moves from one seating chart to the next. I have that working...
  2. M

    Conditional Formatting - Arrow Colour

    Hi - hopefully some one can help me !!! Is there any way when doing conditional formatting that you can change the colour of the arrows ? So say when comparing overheads from budget to actual - if the overheads have gone down thats good !!! But when using the arrows on CF it appears Red ... and...
  3. W

    Display arrow based on cell value.

    I have a worksheet with a column of various sized and colored arrows (AutoShapes) in column T (T5:T19). In column S (S5:S19) I have corresponding numbers. I want to lookup the numbers in column E from the table (S5:T19) and return the corresponding arrow shape in column F. Is this possible...
  4. A

    Inserting arrows into an If() Statment - not working - help

    I would like to insert arrows into an IF() formula in excel for my performance dashboard. I am trying to insert the up arrow, down arrow and side to side arrow using alt+0241, alt+0242, and alt+0243. For some reason the arrows are not showing up. Just these symbols are showing up - ñ, ò, ó Not...
  5. S

    Drawing a doubly bended arrow in excel: how to fit correctly both parts?

    For an application I need to draw a double bended arrow. I draw it by fitting two parts: an “msoShapeBlockArc” and an “msoShapeBentArrow”. However when I print it the two parts don’t fit correctly! Any suggestion how this may be corrected? The function below is called as...
  6. M

    cant work out this formula

    <TABLE style="WIDTH: 710pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=942><COLGROUP><COL style="WIDTH: 172pt; mso-width-source: userset; mso-width-alt: 8374" width=229><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH...
  7. I

    Extract start and end points of arrows in worksheet

    Hi Guys, I am picking up from an old thread here ww.mrexcel.com/forum/<wbr>showthread.php?t=50484 I'm trying to extract data from a worksheet that has activities represented as text in cells, and dependencies between activities represented by default straight arrow shapes going from one cell...
  8. J

    Flow Charts and Macro Sheets

    I'm working with flow charts someone made on macro sheets with buttons and arrows, and want to move this to the back end. Is there a way of making lines and directional arrows in the back end with forms, outside of some special fonts? Like an addin for line arrow objects or something? Any...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top