compare columns and highlight

Hi Goodstart14,

This sounds like you need a CountIf() formula in a Conditional Formatting dialog on sheet 1. If you attach a sample workbook we can deal with a real problem. To attach a sample, click on "Go Advanced" and then the Paper Clip Icon above advanced message area.

Hi,

Use

Formula:

Please Login or Register  to view this content.

If there is no match the function will return #N/A

If you want to highlight those rows then use a conditional format with the Column D error value as the criteria for painting the row.

Hi,

My formula wasn't a conditional format formula.

It's a formula that should go in a helper column in order to identify the items that don't exist. The conditional format formula is completely separate (and different) which will then be applied to this helper column to paint the cells/rows as necessary.

Hi,

Use the 'Use a Formula to determine which cells to format and add

Formula:

Please Login or Register  to view this content.

where A1 is the first cell in the helper column and apply the CF to the whole of helper column A - in this example (or if you prefer the whole of the range of rows that you want to paint). Change A as necessary.