here is the best way I can describe my problem I am having, I tried a few things and I can't seem to hit the nail on the head of what exactly I want. Here are my columns. The asset in column B is comprised of column F and G
A: Location
B: Asset in one system
F: Asset in another system
G: Asset in another system
For example, what is in Column B is 132-10943 and what is in Column F is 132 and what is in Column G is 10943.
Does that make sense? Column B merges both F and G together in one cell. Now I want to be able to highlight duplicate values based on what is in Column G (the 10943) so when I use conditional formatting, the cell with 10943 will be highlighted and so forth. Column G is the unique number in the series, but I do not know how to write it. Logically, I can see it, but I cannot transmit it to paper, which thankfully I am not a programmer, I am just trying to save me hours of work.
Thanks for the help!
Edit: I should add that using the default Duplicate Value conditional formatting won't work because the B and G cells have different values in it, but cell B will always contain a number that is from cell G, so how do I modify that?