change styles of the cell if the value is one of other cells.

[kang]

change style if the cell has the same value of one of other cell values.
for example
if A1 of sheet1 has the one value of B1:B7 then A1 is red.
How can I do that?

thanks.

 

[Gordon]

change style if the cell has the same value of one of other cell values.
for example
if A1 of sheet1 has the one value of B1:B7 then A1 is red.
How can I do that?

thanks.

Conditional Formatting

 

[MartinW]

Hi Kang,

Try conditional formatting in cell A1 using
formula is =MATCH(A1,B1:B7,0)

HTH
Martin