arrow

I've been tasked with adding stupid arrows to our metrics per the governance of our metric process... yay!...... sigh.... So, what I essentially need to do is create an IF statement (I think), that says... When this metric (cell) stays the same, use the RIGHT Arrow shape and color it Yellow...

(Apologies, just joined - this question has been asked here before, but was not followed through) I have received a locked spreadsheet (from a source I wouldn't be able to query) that wraps both horizontally and vertically, when moving between cells using the arrow key. e.g. if the active...

Hello XLers, I want to get some data from a web page. But the From Web button shows me a dialog that allows me to click an arrow button, to get that section of the web page. But the section that I want does not have an arrow? Am I missing something?

This is crazy. My colleague opened a file and now her cursor is no longer an arrow but shows as a cross similar to the cursor one gets when deleting a text box. A real stumper. I can't find an option to change the cursor. Any ideas? thanks Steve

Hi, I have a userform with several textbox (Arrow1, Arrow2,........). When the form opens, the text box are populated from values in a worksheet: code is Private Sub Arow3_Change() On Error Resume Next Me.Arow2.RowSource = "" Me.Arow4 = Application.WorksheetFunction.VLookup(Me.Arow2...

Hi, I have a userform with several textbox (Arrow1, Arrow2,........). When the form opens, the text box are populated from values in a worksheet: code is Private Sub Arow3_Change() On Error Resume Next Me.Arow2.RowSource = "" Me.Arow4 = Application.WorksheetFunction.VLookup(Me.Arow2...

By default, for 3 icons, Excel calculates the 67th percent and 33th percent. 67th percent = min + 0.67 * (max-min) = 2 + 0.67 * (95-2) = 64.31. 33th percent = min + 0.33 * (max-min) = 2 + 0.33 * (95-2) = 32.69. A green arrow will show for values equal to or greater than 64.31. A yellow arrow...

Hi I have big sheet. every 40-50 rows there are 1 or 2 empty rows. I want to highlight the whole sheet (not the whole sheet, i mean my table area only, and i do not want to include some columns that is why I do not want to highlight the whole sheet) So I used CTRL+SHIFT + down arrow. It will...

Hi I'm hoping someone on here will be kind enough to help me out with a little VBA coding to have a Text box display an coloured arrow depending on a cell value. The reason for this is due to having a dashboard look to the sheet i'm working on which is made with a large shape that has a...

So I have worksheet that has a few charts, and on the top of each chart is a 3 year CAGR % surrounded by a circle that is just drawn on. Behind the circle, is a drawn arrow that is pointing "UP", but I want to make it so that if the 3 year % is negative, the arrow would automatically point down...

As a part of a genealogy system I want to manipulate the shapes in a family tree. The rectangles for the PERSONs are named by a PersonID - in the attaced file 29,36 for father and mother and 37,51 for the children. The triangle representing the couple is named "29+36" - the Id of the father...

I'm plotting temperature, wind speed, and wind direction by time. For the wind direction, I'd like to display an arrow or icon that matches the wind direction. For example, if the wind is blowing to the east then I'd like a right pointing arrow on the chart. I'd like to do this for the 16...

Hi im using excel 2010 In my work book i have a inserted an arrow from the insert shape's ive chosen the block arrows section down arrow 4 & Up arrow 5 is it possible that if cell A1=0 then B1 has the down arrow 4 inserted And if A1 value= 1 then the up arrow 5 would be inserted into B1...

Repeat the items: I have our company interest in corresponding cell that I need to repeat, so, <tbody> 0.50882 1.59915 1.59915 1.62267 1.59915 1.62267 0.52931 1.6075 0.50882 </tbody> Will become, <tbody> 0.50882 0.50882 1.59915 1.59915 1.59915...

Hi, I have a Column F that is defaulted to be hidden. I have an arrow that is rightward facing and if I click on it, I want Column F to be shown and the arrow to rotate to face leftward. Then if I click on it again, Column F is hidden again and the arrow becomes rightward facing. I have the...

Hello there, this sounds simple but i cannot fathom it out. i want to include an if function that checks if a cell has numbers between a certain range, i.e. 30-100,1-29,etc and will return a value of an arrow up/down. Is that possible? However i can see that there are functions for 'is...

I've made a spreadsheet using drop down validation lists. It works for all users except for one person. They are using Excel 2007 on a Windows 7 computer. They cannot see the arrow to show the list of options. The cell is not locked. If the user types in a valid entry, it works. I've tried...

Hi Guys, I'm using a custom point arrow to change the conditional formatting icon set. But cannot seem to get the right if function as well as the rule description. My conditions are: if the percentage is an increase of more than 30% - red arrow points up if the percentage is an increase of...

Hi Guys, I need help. I want to use Icon set - 3 arrows. I want to include an arrow that indicates increase and decrease daily based on it's yesterday data. <tbody> date Cost 12/25 549.38 12/26 821.03 49.45% 12/27 300.23 -63.43% 12/28 360.00 19.91% 12/29 504.00 40.00% 12/30...

Whenever I test a macro, (with what is normally a non-successful result) I cannot Undo the operation by clicking the Undo arrow to go back, I have to close the file and start over with a fresh copy. Hugely annoying...Anyone know why?