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

  • Thread starter Thread starter kang
  • Start date Start date
K

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.
 
kang said:
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.
Click to expand...


Conditional Formatting
 
Hi Kang,

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

HTH
Martin
 
Back
Top