| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Cell Styles | New Users to Excel | |||
| making copied cells change with change in original cell | Excel Worksheet Functions | |||
| Excel: Toolbar button for Formatting cells to date STYLES etc | Setting up and Configuration of Excel | |||
| How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
| Line styles for Cell Borders | Excel Discussion (Misc queries) | |||
Linear Mode
