apply

I want to apply color to the first 10 characters in cell B63. It has a formula in the cell. I selected conditional formatting, then New Rule, then Use of formula to determine which cell to format then I entered this formula =LEN($B63)=10. It worked and applied the color to the first 10...

Hi I need to use a filter on my pivot table. (Placing the field into the folder box) I only want this to apply to one of my columns - is this possible? Jess

Hi, This is a bit frustrating. I've applied code to filter data using the autoFilter function but when I apply a new line with AdvancedFilter it appears it clears the filtered range and copies over all data With Sheets(1).ListObjects("Table13256").Range.AutoFilter Field:=22, Criteria1:="<>"...

Hi, I received 1 excel file contained values but having 2 or 3 spaces after figures, I think this is formatting issue, what formula can I apply to get figures only. In the below example x means space Current figures 100xx 300xxx 210x Wanted 100 300 210

Hi all, I have a spreadsheet with a column containing URL's. I'd like to apply a formula to the entire column so that, if a URL has a question mark, delete the question mark and everything right of it. I found this formula: =LEFT(A1, FIND("?", A1&"?")-1) Probably a basic question but, how...

Hi, I have the following code, but how can I apply this to rows below A5 to act in the same way? For example, I need this to be applied to A5:A44 and then A48:A87 (possibly for more rows below so I need the code to only perform the hide/unhide within the specified areas). Also, is it possible...

Hi, can anyone help with this Array Formula? I have formulas that I add to sheet1 through vba that adds rows from columns "A", "B" & "E:K" to columns "AI","AJ" & "AK:AQ" and then apply autofill down to the number of rows required. The formula for Columns "AK:AQ" puts the values in order small...

Hello Mr Excel gurus, As the title says, I'm trying to make a simple macro to apply to a button, so I can update the footer details of a Worksheet. I can accomplish all of these steps individually, however when I manipulate the "font colour" property, I can't seem to get things to work with...

Hi, I have written a macro to apply a formula to a range of cell the following is working just fine 'Worksheets("TRANSPORT").Range("N15:N34").Formula = "=MIN(K15,MAX(D15*I15,J15))*INDEX(ROE,MATCH(G15,DEVISE,0),3) but this formula is not the complete version that does not work Here the...

Hi, Can you advise please the correct way to apply Ucase for when i insert a new row each time at A6:H6 I have this code below but keep getting Run Time Error 13 Private Sub InsertNewRow_Click()Rows("6:6").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Range("A6").Select...

I have a standard report which I need to sort in the same way everytime. Is there a way to save the "sort" sequence and apply instead of re-creating each time? Thanks in advance!

Hello, I have some conditional formatting to apply across numerous rows in my worksheet and I would like to speed up that process as much as possible by using VBA. Ideally I will select some cells and then the VBA would run through each row and apply the Red (High) - Green (low) cell colour...

Hello, I have data in columns A:B that changes in the number of rows. How can I apply a function I wrote (RemoveChar(B2)) to column C2:End? I can't seem to figure out how to apply the formula downward until the last data point at the end of column B. Thanks!

Hi all, I am trying to apply a simple conditional format where cells with the same value are highlighted. The problem I am running into is that the data I want to apply the formatting to is in every other row (2, 4, 6, etc). The formatting works fine if the the duplicate value appears in the...

I have a need to apply conditional formatting to a range of cells based on the value of a corresponding value in another range. I have managed to do this for a single cell, but can not figure out how to apply it to the range below is the formula that works on a single cell =$J$7<TODAY()-30...

I want to conditionally format cells in the range A1:A200 that contain any string. If a cell is blank, no formatting should apply to that cell, but once any string is entered in a given cell, that individual cell should have its fill changed. Any ideas?

I have a conditional rule in cell I2 if less than 02:00 and want to know how I would apply the rule so it colours the whole row from A2 through to K2 Thank you

Hello folks. PLEASE, I have a macro, and I see some kind of loop concept to apply here but still thinking, so PLEASE somebody can give me a hand here. Sub Coe_fficient_trend_line() Range("P5").Formula = "=TRUNC(TREND(B3:B20))" Range("P6").Formula = "=TRUNC(TREND(C3:C20))" Range("P7").Formula...

Hi I have a macro which refomats an excel file. I want to highlight rows where value in far right column is greater than zero. Last column position is variable which I can select and apply conditional format to column, but how do I apply to complete row. Suggestions would be much...

Hello, Please could any help on a vlookup issue? i have the following lookup =HYPERLINK(IF(IFERROR(VLOOKUP($C$29,Supplier,11,FALSE),"")=0,"",IFERROR(VLOOKUP($C$29,Supplier,11,FALSE),""))) I have a invoice and when i populate the suppliers details i would like to have a hyperlink to their...