search and highlight

  1. J

    Using value criteria in two columns to find row in which two columns most closely match the criteria

    Hello, So I have 80 or so large data sets that I have smoothed and then found the slope between each point. I then calculate the average change of the slope along the curve. I would like to search for a row in the two columns where the average slope percent change is less than 1% in one column...
  2. E

    Selecting a specific range based on a stored value

    Hello, I'm new to VBA and have been developing a macro for a database. I've completed about 95% of it and it all works successfully. However, I'm having trouble with the last thing I want it to do, which is replacing data. So here is the situation: I have a form and a 'master' sheet. The...
  3. A

    Using Conditional Formatting to find data from multiple worksheets

    I currently have a workbook with two worksheets inside of it that has some of my clients names in both. Some matching, and some missing. I would like to use conditional formatting (or some other search method) to search "Sheet A" for names not found in "Sheet B" and highlight/format these names...
  4. A

    Using Conditional Formatting to find data from multiple worksheets

    I currently have a workbook with two worksheets inside of it that has some of my clients names in both. Some matching, and some missing. I would like to use conditional formatting (or some other search method) to search "Sheet A" for names not found in "Sheet B" and highlight/format these names...
  5. Manolocs

    search in a list

    Hello, I have a large list about 10K rows. This list will be updated constantly but I need a way to do it, when a new list arrives I need to add only the words that are not in the original. Any one has an idea how can I do this? The list has two columns but the search is only in the first...
  6. K

    Cond. Formatting w/ Formula not always working - Why?

    Let me try this again... I have two spreadsheets (in 2 workbooks). One SS is a listing of Store Samples, the other is a Price List of products. On the pricing spreadsheet, I would like the cells in the Item number column to be highlighted if the cell contains text (regardless of case) that is...

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