In an Excel spreadsheet, I want to highlight any cell in the sheet that has the same value as any one of six cells in the first row. i.e. cells A1 through F1.
I will change the values in A1 through F1 daily & need to see if any of the 200 or so other sells in the sheet have the same value.
I thought Conditional Formatting could do it but it won't allow me to target the value of more than one cell, i.e. I can format to say if any of these cells are equal to A1, then highlight the cell, but I cannot say if equal to A1 OR B1 etc..
Any takers? :)