Hi all. Hopefully a simple one!
I have two columns of names, a third column has a simple IF statement that generates a YES if the two names in the same row are the same. So far so easy.
I have another sheet in the same WB with another long list of names. What I can't figure out is how to highlight the cell that contains names on the 2nd sheet that have generated a YES on the first sheet. I'm hoping someone will tell me how simple it is!
Thanks for any assistance guys & girls....
Last edited by SteveB666; 11-29-2020 at 07:21 PM.
Hi
Is it possible to upload a desensitised sample of the WorkBook. It would make life simpler in providing a solution for you.
Cheers
And done... I hope. Thanks FoxSeaLady. The highlighting in the 2nd sheet has been done manually by me. This is what I would like automated. The real workbook is about 10,000 rows long.
Here's one possible solution. While selecting the cells that you want to highlight on Sheet 2, go to Conditional Formatting and select the option to Use Formula to determine cells to populate.
In the formula box, try this:
=ISNUMBER(MATCH(1,(Sheet1!$B:$B=A1)*(Sheet1!$A:$A=A1),0))
(I left it as checking the whole column a B and A, but I suggest you use the actual rows that you have data.)
Then format as you please.
Thanks Greg, I'll try that out.
Hi Greg, if I want to drop the area checked I'd change it like this right:
=ISNUMBER(MATCH(1,(Sheet1!B1:B10=A1)*(Sheet1!A1:A10=A1),0)) ?
Hopefully you didn't read this comment! I was being foolish :-)
Last edited by SteveB666; 11-29-2020 at 11:51 PM.
Using countifs:
=COUNTIFS(Sheet1!$A$1:$A$10,A1,Sheet1!$B$1:$B$10,A1)>0
Quang PT
Within conditional formatting bebo?
Ah yes, that works as well. Thanks to both of you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks