Hello All,
Here is what I am trying to accomplish.
I am trying to match a single cell from column A in sheet 1 to any cell in column A in sheet 2. If the strings match, no conditional formatting should occur. But if my cell in sheet one is not found in sheet 2, I want the cell in sheet one to be highlighted as an error.
Example Here: https://docs.google.com/document/d/1...it?usp=sharing
Im not sure where to start? Is this a vlookup? Any help would be greatly appreciated.
Last edited by CMXVII; 11-01-2017 at 01:49 PM.
Figured it out using =SUMPRODUCT. Thanks.
In conditional formatting try...
A1=Match($A$1,Sheet2!$A:$A,0)
HTH
Regards, Jeff
the conditional Formatting rule:
Conditional Formatting > New Rule >
- Use a formula to determine which cells to format
- Format values where this formula is true: =AND($A1<>Sheet2!$A:$A)
- Applies to: =$A$1:$A$10 | Change range accordingly
See attachment
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.Originally Posted by CMXVII
Done. Thanks for the heads up.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks