applies

  1. R

    transpose and remove duplicates

    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...
  2. LaurenHancy

    Conditional formatting when pasted to a different row

    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...
  3. H

    Conditional Formatting using VBA?

    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...
  4. D

    How can I dynamically change the range (applies to) for a conditional format

    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...
  5. SRMPURCHASE

    Copying conditionally formatted cells

    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...
  6. P

    IF Formulas

    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...
  7. P

    IF AND Forumlas

    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?
  8. B

    Conditional formatting - highlight cells based on text in another

    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"...
  9. W

    Charting colors

    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%...
  10. E

    Repeating macro

    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
  11. J

    Conditional formatting based on criteria

    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...
  12. C

    Offset

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

    Conditional Formatting - "Applies to"

    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.
  14. T

    Conditional formatting

    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
  15. Weeble

    Vba convert number stored as text to number in a table

    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...
  16. D

    Stop auto date formating

    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,
  17. C

    formula help

    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
  18. Welsh Mark3

    Commision Formula

    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%...
  19. sharky12345

    Identify last used cell in column with blanks in between

    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.
  20. K

    Conditional Formatting Problem

    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...

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