How to copy and paste data from a column into another column if it is highlighted using conditional formatting

Question

5.00/5 (1 vote)

See more:

while comparing two columns A and B I am able to highlight the unique data in both the columns using conditional formatting but now the problem is that I want to copy and paste this highlighted data from B into the column A so I am looking forward for a VBA code that can do this task of copying the highlighted data from Column B and paste it into the column A

Like
A12= dog
B12= cat
B12 is highlighted with RED using conditional formatting
so IF highlighted with RED, B12=A12
final output:
B12=cat
A12=cat

What I have tried:

I know how to copy data from one cell to another

Sub CopyValue()
ActiveSheet.Range("A12").Value = ActiveSheet.Range("B12")
End Sub

But how to apply the after highlighted part is a little difficult as I have no idea of VBA.

Posted 16-Aug-18 1:58am

bhargavsingh4821

Updated 16-Aug-18 5:39am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gerry Schmitz · Answer 1 · 2018-08-16T05:40:00

Solution 1

You don't actually have to look for "RED".

You are using "conditional formatting"; therefore, test the "condition" (not the color).

In any event, here's a "color" link:

Get Excel cell style in VB[^]

Posted 16-Aug-18 5:40am

Gerry Schmitz

Comments

bhargavsingh4821 17-Aug-18 4:39am

Sorry but I dint get this post The problem here is how to test that condition and copy that highlighted cell's data to the cell from which its comparing.

CHill60 5-Sep-18 5:13am

I was just about to answer your other question about moving a button when you type data into a list, but the question has been deleted.
If it is still a problem then post it again and reply to this comment and I will post a solution for you.