conditional

  1. J

    Conditional Table Array for Vlookup?

    Hello, I am trying to vlookup a value for a competitor product based on 3 criteria (that determine product group and its exact specifications). I was hoping I could use some logical function, that would then somehow choose(locate) and use a desired table array from which to look up the data...
  2. D

    Highlight cells with Conditional Formatting using large range of values

    Hello all, this is my first post. I’m having an issue with Conditional Formatting. I work in a warehouse, and I am having issues in a certain section of the warehouse with items being split across several different stock locations rather than being consolidated into 1 or 2 locations. There is...
  3. F

    Vlookup in database for multiple cells

    Hi, its me again, I have another problem, the thing is that I want to find the name of multiple Stores, I have the store id and I have the Stores Database in another worksheet, the the thing that I want is to run a macro that search me automatically every code that i put in a extensive...
  4. A

    Conditional Rank without duplicates

    Hi Excel friends, Looking to solve this problem without using an array formula: name value Conditional Rank (formula required to solve for this column) a 2 1 a 2 1 a 7 3 a 5 2 a 5 2 a 15 4 b 15 3 b 15 3 b 17 4 b 2 1 b 11 2 Basically I want a formula to give me...
  5. T

    Using VBA to combine headers (based on name) and concatenate columns based on conditions

    In ponctualy receive a file that I would like to reorganize. I am thus looking for specific headers names and either renaming them and copying data or doing more complex operations. In the simplest case, I am only renaming columns and pasting the new columns headers and content in a second...
  6. K

    VBA code to insert a variable # of rows between each existing row matching certain criteria. Help please!

    Hello, I need some help on VBA, please. I've inlcuded an short example below of what I am trying to achieve. I am trying to figure out the VBA to insert a variable number of rows (based on the value in Settings!C13) between existing rows on the worksheet 'UNIT_PRICE_COMP'. Some rows are...
  7. R

    Macros to copy new data

    Hi, I'm trying to compose a code in which I'm copying new values from Sheet3 (in code I select range by hand), but I'd like excel to keep track of which rows are new. Now I select values from Sheet3 column A based on if value from same row's D column is equal to Sheet2 B column value. Also I...
  8. F

    checkbox with condition on textbox

    hi, i want to make a command button which calculated a specific formula the thing i want to do is to grab the data from a textbox and multiplied with the costo of each type, but the textbox only appears if the checkbox is in its value true, for example (it is in spanish): the checkbox is not...
  9. Q

    IF Formula/Conditional Formula Help

    I am attempting a simple reinvestment strategy. In the scenario shown below every year in which the store hits $5,000 in Running Sales, an investment of $5,000 is made to open a new store. So in theory, a year in which $10,000 in Running Sales was generated 2 new stores would open. However, a...
  10. L

    Create column with conditional

    I everyone, im new in power bi / power query and I need to know how to create a column in a table IF the value of a specific column is between a range of one of two different column values. Something like: create a column 4 where the value is the same as the value in column 1 IF this value is +...
  11. D

    CONDITIONAL FORMATING LAST CELL IN COLUMN GREEN IF GREATER THAN ANOTHER CELL

    I want the last cell in column L that has a number to be green if it is a larger number than cell D11
  12. W

    Sum conditional formatted cells

    Hi all, I am trying to sum all of the green cells (see picture @ https://ibb.co/vjVRrBC). Green cells are formatted using a conditional formatting formula rule. The purpose of the formating is to highlight every cells in columns U that I have room for in my budget (C8) starting from the top...
  13. L

    Conditional Format formula

    I would appreciate any help with the following. A1 contains the name of a city say Reading. F1 contains a mnemonic for that city which in this case is logically RE. However the RE is not always the only letters in the cell. So what I need is a CF formula that will check if the first 2...
  14. T

    conditional formatting

    Hello, if the delta between cells H2 and J2 is >=2% color cells red. thanks in advance
  15. T

    Conditional Formatting

    Is it possible to use conditional formatting to highlight a cell if it is the active cell and how would you do that? Thank you
  16. A

    highlight row and column

    I need to highlight range in excel. for eg. if i select "F6" in excel then column F and row 6 highlighted with color. is this possible with conditional formatting ?? or there is any other option to do this.
  17. D

    Conditional Formatting with two values

    <tbody> 123456 Murdock 123555 Murdock 123456 Murdock </tbody> I'm trying to get the first and the third rows to get filled in a Color since both the ID and the Name are the same value. The second row should not be filled. Any ideas?
  18. L

    conditional formatting - bar based on value

    Hi I created a conditional formatting based on the value of the cell excel would insert bar as below. The bar can move from left to right or right to left. My question can I create similar bar but move from bottom to top? is that possible? Thank you very much
  19. K

    Conditional formatting each next step

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here the below is my example I need Formula is preferable or an alternative VBA for conditional formatting to highlight each next step pattern in the complete row as per "specific pattern shown in the cells C4, D4 & E4 which is changeable as...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top