multi cells

  1. S

    Is it possible to code a button to open a menu to select certain cells to highlight a certain color

    Hi , im not even sure this is doable (probably but idk) , basically what i want to know is if there is a way to code a button or something that opens a menu and this menu will do 2 things , #1 - provide a list of cells to select that will show in the list as 1-62 , you can select 1-5 and then 7...
  2. S

    Removing & adding characters from multiline cell

    Hi, I am wondering how to remove, in this case, the last 4 or 5 characters from a multiline cell with many links and add/replace new text. So after the jpg I want "?raw=1" instead of dl=0; Thank you so much beforehand if anyone can answer. Thank you...
  3. M

    Find items 1 spreadsheet & show them on a different spread sheet-

    I have an "expenses" spreadsheet, an "income" spreadsheet and a "Shipping Account" spreadsheet. In the 'expenses' spreadsheet: Column B3:B200 contains descriptive text which is selected from a drop down menu I created using Data validation. This contains several descriptions and 3 of them all...
  4. H

    Conditional Formatting on Multiple Cell Values

    Hi, I am completely stuck on figuring out how to do this one. not sure if I am just makig it way too complicated. I am wanting to highlight the cell A1, if O1 does not match the value of R1, but P1 does match the value of R1. I also need to adapt this so there will be more cells that need to...
    • hellojamielee
    • Thread
    • conditional format conditional formatting formula multi cells multi conditions
    • Replies: 3
    • Forum: Excel Questions
  5. J

    Cell() syntax for multi-cell ranges

    Can someone help with the syntax for Cell() for a multi-cell range? Range(A1) is expressed as Cells(1,1) Range(A1:B2) is expressed how in Cells()? Thanks

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