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

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.

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

"kang" wrote in message
...
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

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

Hi Kang,

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

HTH
Martin




"kang" wrote in message
...
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.

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

Great.
thanks.

MartinW wrote:
Hi Kang,

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

HTH
Martin




"kang" wrote in message
...
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.