vlookup + colour

  1. S

    Need to highlight matching rows (or) non matching rows

    Hi, In my excel, i have two sheets. in sheet1, i have three columns with almost 3000 rows. in sheet2, i have two columns with 230 rows. sheet2 was like a child sheet, all these data exists in sheet one. i need to exclude non matching data from sheet one. the condition i have is, two...
    • signup
    • Thread
    • excel & lookup & search sheet2 vlookup vlookup + colour vlookup + index + match
    • Replies: 0
    • Forum: Excel Questions
  2. V

    Copy and Replace with Vlookup Formula

    Hello everyone, My goal is to find all YELLOW highlighted cells that are currently empty, and replace it with a vlookup formula like this: =Vlookup(A1,A:Z,2,False) The issue is when you use the Find and Replace function, the lookup value of A1 is an absolute value. I need the lookup value to...
  3. K

    Excel vlookup data/text and colour? or another formula

    Hi, I'm using vlookup to find data, but the data is highlighted in different colours and I need this to appear as well as the data/text. Is there a way to do this? The data is individually highlighted with a specific RGB colour for each one and so far could not think of a way to do this. In...

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