Hello everyone,
I have 3 columns with different values. ColumnA- has permanent number list and ColumnB and ColumnC have the values that are changing every day.
My task is to check first Values from ColumnA and ColumnB for duplicates and have them highlighted with one color(yellow), then have values from ColumnA and ColumnC check and highlight the duplicates with another color (red). I use the conditional format to find and highlight the duplicates, but as soon as I change the values in ColumnB and ColumnC the highlight disappears.I am wondering if there any way to make the highlighting in ColumnA permanent?

Thanks.