one way - assuming you mean if the cell's value matches ANY of the other 8
cells

use Formula is

=sumproduct(--(A1:H1=M1))=1

and set your format


"Craig" wrote:

I need a particular Cell to Highlight if it is the same (or equal to ) 8
different cells in the 1 row