Member Avatar for 4ukh
4ukh 3 Junior Poster in Training

I want a macro that does the following:
Let say I have two ms excel sheets named as Sheet1 and Sheet2
Sheet2 has two columns A and B (populated with some information)
What I need is, check Sheet2 column A values in the Sheet1 column C if value exist highlight the cell with let say green color and again check for Sheet2 column B values in Sheet1 if there are similarities highlight the cell with red color.
That’s it… for me it is quite difficult but for you guys of course not.

Thank you,

  • 1 Contributor
  • 0 Replies
  • 57 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.