• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditionally remove highlighted colour

r@1234

New Member
all files are located in desktop
vba is placed in seperate file
only 1 file is opened and that is vba code placed file so for this process we have to open the file as per condition and after the process completed all files should be saved and closed except vba placed file
If column R of 1.xls file is not in minus(-1,-0.5 or xyz any negative number) then see the column E data of 1.xls and open 2.xlsx and match column E of 1.xls with column A of 2.xlsx
and if it matches then look for any highlighted colour in that row and if any highlighted cell in that row is found then remove the highlighted colour and save the file and close all the file
So plz have a look and do needful
 

vletm

Excel Ninja
r@1234
As a new member, reread again
 

Marc L

Excel Ninja
Same thread than Leonardo1234 with same writing style,​
both from the same city and both non respecting forum rules ! :rolleyes: …​
 

r@1234

New Member
i was just trying to solve this problem i am not a professional one
i know little about vba so i was unable to make the code for this so i was just trying to take a guide from this forum sir
 

vletm

Excel Ninja
r@1234
Did You reread that link?
There are many good hints how to continue...
How possible, that You're writing almost same style as one other member?
 

r@1234

New Member
i have only 2 question why i will unnecessary ask questions and i will waste ur precious time
i know u r programmers and u r busy in driving technology
 

vletm

Excel Ninja
r@1234
I really won't even start to guess
1) why do You ask some questions, if You cannot give needed information.
2) I've 24/7 time as everyone else.
If You cannot help Yourself to answer questions.
I don't need those answers - You need those answers,
that You could get something, which You are looking for.
 

r@1234

New Member
sorry if i have not mentioned complete details in my post
i just wanted to say that i was unable to make the code thats y i was taking guidance from seniors
 
Top