tick

In cell A1 I have a formula which comes up with either 0 or a number greater than 0. In cell B1 I want: 1. A tick symbol to appear if A1=0 2. A cross symbol to appear if A1 >0 Not sure how to do it or what formual would allow this as I have never dealt with symbols in formulas? Can this be done?

Is it possible in a ListBox that has its row source from a spreadsheet that it can display a symbol like a Tick if the value in the row source was the value "YES" for example ? I have a column that will only have the value YES or No and would like to display a Tick or Cross rather than the...

Hi Guys, Good day. I have a project that i need your help and it goes like this. I will be using a multiple check box and if i tick a checkbox it would automatically go to a certain sheet. Thanks for your advance help.

Hi there, I am making a userform. I have to checkboxes, checkbox1 and checkbox2. I want to make it such that user can only check one of them at tiime. And I also want to make it as mandatory question for the user such that he or she needs to tick one of the checkboxes! thanks for your help

I have a graph that I want to go from 0 to 80000 in 10000 unit increments on my x axis. I want my data to fall not on the major tick marks (ie: a 25000, 45000, etc). How do I set this up?

Hi I can anyone help please i have 2 worksheet, worksheet 1 has all patients names in column A2 - A22 and address in B2 -B22. In column C I have a checkbox alongside each name/address. What I want to do is tick the checkbox and the name and address of the person on that row will move to...

Hi Everyone, I have the macro below which I use to treat my own tick boxes in cells "a" = tick It works great except you have to click away before it will change again. I was woundering if there was a bettter way i could do this? Basickly I want a macro that gives me an "a" in the cell i click...

Hello, I'm trying to display a tick or cross in F if a variance (D-C) is less than or greater than C but i'm having a total mind blank. Should be easy but its not! I've got the wingdings side easily just the formula is stuffing me around So Num1 ...Num2 ...Variance.....Mark...

Good Day Could anyone please help with me with a simple bit of code required to add the details of a userform to the bottom of a list The userform looks like this --> https://drive.google.com/file/d/1q762SqtZkq6knLa9uChjxCy-9PxuUcop/view?usp=sharing The List is located in Column KD. The...

Hi Everyone, I'm open to ideas here but I very stuck. Well have a Sheet that has a range in it that I made look like a big Graph of squares, It Range is G15:Z45 Each cell is about 3 cm square so nice and big, I want to be able to click on a cell and have it make a Tick appear or Disappear and...

It seems like whenever I add major gridlines to a chart in Excel 2007, the minor gridlines turn into tick marks. And whenever I add minor gridlines, the major gridlines turn into tick marks. I've even tried clicking "Major and Minor Gridlines" in the chart layout menu. But all this does is give...

I'm using the following formula =IF(ISNUMBER(SEARCH("1a.",,$AK2)), "Yes", "No") To search with a cell for 1a. The problem is I get a Yes in cells with 11a. or 111a. What is the tick to find 1a. and 11a. and 111a. distinctly? Thank you!

Hi, I'm looking for a way to seperate sets of bars in a graph. I've been inserting a gap by inserting a column between the data, which isn't ideal. Is there a 'proper' way to do it? A tick box or something?!?! Thanks!

Hello All. I have been on this for hrs, completely done my head in,, any advise greatly apreciated. I have a sheet with column H & I I want to be able to show a tick or a cross in, if the assigned list shows either a YES or a NO. I just cant get it to work. (I did originally try windings, I just...

Hello All A bit of a long shot this one and I've tried so many things to get it working including MATCH, VLOOKUP, INDEX and a combination of all of them however I simply can't get what I am attempting to work and just wondered if it is even possible. I have a worksheet set up with as below -...

Hello All. I have a spreadsheet with about 450 cells that need to have a tick or a cross inserted into them. I've found a great bit of code here; https://www.extendoffice.com/documents/excel/4558-excel-tick-and-cross.html which is 80% of what I would really like the vba to do,,, code so far...

Hi all, I'm trying to create two graphs. One is a column graph. The other is an x y scatter. But I have the same problem for both. I need to remove the first and the last tick marks on the x axis and their labels. Note that the tick marks must be located outside the axis (not inside). I'm not...

Is it possible to show a tick mark on a user form? I want to show the user then the entry made is either valid or invalid with either a tick or a cross. TIA

I have a .pdf from that requires the user to tick boxes, fill in text boxes, etc. I was going to recreate this .pdf form in an Excel sheet but I was wondering if VBA can tel the .pdf what boxes to tick, text to enter, etc from selections made via a worksheet? TIA

Is it possible to have a tick box (or alternative?) in a cell so when it is ticked it scores a number specific to that cell in an overall score. For example, if I have questions in column A and then 3 answers in column B, C and D that are tick boxes (i.e. with heading above them bei9ng Yes...