A Ridiculously easy and fun way to compare 2 lists Select cells in both lists (select first list, then hold CTRL key and then select the second) Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values. Press ok. There is nothing do here. Go out and play!

Find duplicate values in two columns Highlight column A by clicking the column header. ... Select the Conditional Formatting button under the Home tab. ... Select New Rule from the Conditional Formatting drop-down list. ... Select the ' Use a formula to determine which cells to format' option. ... Enter the formula provided in the text box.

Compare two lists and highlight matches and differences Select the cells you want to highlight (you can select cells within one column or in several columns if you want to highlight entire rows). Click Conditional formatting > New Rule… > Use a formula to determine which cells to format.

Just to make it simpler and easier to read, let's name the two lists as 1 st and 2 nd Lists of Customers as shown below. Select both columns of data that you want to compare. On the Home tab, in the Styles grouping, under the Conditional Formatting drop down choose Highlight Cells Rules, then Duplicate Values.

If you're going for a very formal look, you should wear black socks with a black suit, navy with navy. If you like, you can match your socks with your trousers, as you're doing. But matching socks with your shoes isn't such a smooth move.

So you really should not worry as whether the color matches gold and think more about the mood you want to create with Gold. ... Gold looks especially good combined with black, white, red, royal purple, navy, brown hues, emerald, aquamarine, military green, hues of greens & blues in general.

Gold matches with any bright colour, it can be combined with dark blue or red , orange or any thing ,don't try to match it with ligh colours like baby pink or light blue. A lot of colours can match gold. White, black, purple, cobalt blue, turquoise. White goes great with gold, for a day to night event.