1. D

    Excel conditional formatting does not work!

    Please help, Super simply: I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting: As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...
  2. R

    Conditional Formatting and Percentages

    Hi All, I have a spreadsheet which, in column L there is a percentage that is based on the numbers in columns D and G. I would like to create a conditional format that says: -if column L is less than or equal to 3% format the entire row green -if column L is between 4 and 6% format the entire...
  3. D

    Conditional Chart Data Range

    Hey guys, I have a workbook that charts data for various dates. I want the chart (called "Chart 6") to display different ranges of data as the years go on. When I select my chart and go to Select Data, then the Select Data Source window pops up. Currently, the chart is displaying data from the...
  4. D

    VBA Conditional Calling Based on Current Date

    Hello, I have a few different functions that are set up to do different things depending on the current date. List of functions: 2020_Tasks 2021_Tasks 2022_Tasks Is there a way, using VBA, to only call the '2020_Tasks' function if the current year is 2020, and then to continue moving through...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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 +...
  15. D


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

    Sum conditional formatted cells

    Hi all, I am trying to sum all of the green cells (see picture @ 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...
  17. 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...
  18. T

    conditional formatting

    Hello, if the delta between cells H2 and J2 is >=2% color cells red. thanks in advance
  19. 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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...