I need help with a conditional formatting formula.
I have a list on sheet1 Column C that I want to highlight yellow if it appears on sheet2 Column A:A (this list keeps adding up).
At the end, I will create a macro to run this but I primarily need help with the formula.
Thank You
If you are familiar with CF, you would do it the exact same was as if you where doing it in the same sheet.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This is what I have so far but its not working as it should.
=MATCH(C2,INDIRECT("sheet2!A:A"),0)
I am only getting a few matches but not all on Column C. Also, some are getting highlighted that should not.
Why are you using INDIRECT, and not just a regular reference there?
=MATCH(C2,sheet2!A:A,0)
I used this formula on the last column and hid it in the macro at the end:
IF (COUNTIF(xyxyx!$A:$A, G2)=0, "true", "nottrue"
and just highlighted the true. worked well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks