Thread: change styles of the cell if the value is one of other cells.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
kang kang is offline
external usenet poster
  
Posts: 38
Default 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.


Reply With QuoteReply With Quote