applies

Hi Guys I have the following link https://www.dropbox.com/s/i77n2rc0c5pgfk7/transpose.xlsx?dl=0 Sheet1 is my data table and Sheet2 is the output. You will notice that there are five Ref Numbers which are the same(TV201801/000380). These Ref numbers are assigned to the name of the persons...

Hi All, In need for some urgent help. I have figured out how to SumConditionColorCells condional formatting cells. I am summing each working day for each month for 13 different names with 5 different conditional format rules. The only way this will work, is if the conditional formatting is...

I have a large spreadsheet with 14 different conditional formatting rules. I'm tired of having to weed them out everytime I blink. If I did it with VBA would it eliminate that problem? If so I would like to do that. I can likely figure out how to set up most if not all of them once I have...

I want to use a conditional format to add 'Data Bars' to a portion of a table column. I created a formula with OFFSET() to set the correct range and gave the OFFSET formula a defined name. When I use the name in the Applies to field for the conditional format, it gets changed to an absolute...

I consistently use the VBA below to insert a blank row above a row of data and copy it up to the newly inserted blank row, then edit a cell or two in the new data row and save the file. Sub COPYROWINFOUP() With Selection.EntireRow .Copy .Insert End With...

How do I write the following excel formula: If B3 < 15 then the following applies 25*2=50 AND IF B3 > 15 but < 25 then the following applies (25*3) AND IF B3 > 25 but <50 then the following applies (25*3) + ((B3-25) *2 AND IF B3>50 but < 100 then the following applies (25*3) + ((B3-25) *1.6...

How do I write the following excel formula: If B3 < 25 then the following applies 25*3=$75 AND IF B3 > 25 but < 50 then the following applies (25*3) + ((B3-25) *2 AND IF B3 > 50 then the following applies (25*3) + ((B3-25) *1.5?

Hi guys - hopefully another easy Conditional Formatting issue. In my workbook, if cell J2 contains YES, I want E2 and F2 to be highlighted Green and so on throughout the sheet on a row by row basis. I have a rule in conditional formatting corresponding to E2 and F2. Formula: = $J2="YES"...

I have a Pivot Table that contains 3 columns. Column A is the date that the data applies to (10/28/2018, etc.). Column B is the individual category the data applies to (<6 Mo, >6 Mo <12 Mo, etc.). Column 3 contains the individual amounts that apply to that category, based on that date (.0030%...

Hello everyone, I am looking for a marcro that can copy and paste cells. The value of cell X must be copied to a cell X + 6. So A1 text "Xteam" has to be copied to cell A7, this up to cell A380. The same applies to cell B2 + 6. How can I do this, I can not do it thank you in advance elmalle

In worksheet I have drop down YES/NO in column P If P is "Yes", I want Q:U to be all filled with say colour red If if P is "NO" then no conditional formatting applies But also if Q has a "Yes", the everything P:U turns Yellow And if Q is a "NO", then P:U is Green Could you please assist...

How would you right a code that applies to a cell using the OFFSET FORMULA?

I am trying to apply condition formatting to select cells; they are not in consecutive rows. Can I use the "Applies to" field? I tried to enter in the "applies to" field: E4,E5,E7,E8,E9,15, but it didn't work.

Assume I have to rows of data. If A1 < A3, then highlight it. I can do the above for one cell but how can I extend it so this rule applies if B1 < B3, C1 < C3, etc.? Thanks

so after abit of googling I found a formula that almost does what I need. Sub ConvertTextNumberToNumber()<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas...

Hello, I need help with a long column that I need to substitute a character . with - in each cell but for some cells it applies the date format and messes up the outcome. I ve tried everything,

Hi. I have a formula for cell F7 The formula is =E7+$L$2. E7 contains a number (18). L2 also contains a number (0.5) so it adds 18+0.5 However if E7 contains a number with NIE preceding it eg. NIE15 I would like it to ignore the'NIE' and just add 0.5 to 15 Thanks in advance

I'm looking to create a formula that calculates sales commission from monthly sales achieved. Cell A1 will contain monthly sales achieved. The commission structure is o 0-2000,0% o 2001-4000,15% (retroactive to dollar 1) o 4001-6000,30% (30% applies to 4001-6000) o 6001+,45% (45%...

Can anyone show me how to identify the last used cell in a column that has a combination of data and blank cells? The rows this applies to is 8:214 so I just need the last cell within that range, (column L), that has a value.

Here is the data validation rule I have: Format values where this formula is true: =$BK$6="W" Applies to: =$A$6:$S$6 I want that formula to be applied to the next 100 rows. Here's the process I’m following: Select Range A6 to Range S6 Copy Select Range A7 to Range S105 Paste Special...