MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Format if there is more than one of the same value in the same column

Posted by Gary on November 15, 2001 12:33 PM


Does anyone know which formula to use in the conditional formula, formula box so that the cell will change colour if there is more than one instance of a value in a column?

I.E. if I have a load of values in column B and there are more than one cells which have the value A03D2 in them.


Then the cells adjacent to both A03D2 will need to change colour.

Thanks in advance,


Gary Hewitt-Long

Posted by Juan Pablo on November 15, 2001 12:43 PM

I have tried recording a macro to do it, but when the form box is up - I can't stop the macro.