| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change the color of a range of cells
Hi,
I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all thse 5 cells depending up on the value in cell 5. Thanks in advance for your help. SR |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Change the color of a range of cells
rows/columns?? -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... Hi, I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all thse 5 cells depending up on the value in cell 5. Thanks in advance for your help. SR |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Change the color of a range of cells
rows
"Don Guillett" wrote: rows/columns?? -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... Hi, I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all thse 5 cells depending up on the value in cell 5. Thanks in advance for your help. SR |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Change the color of a range of cells
I have 7 different values in the cell "K1" such as AA,BB,CC,DD..etc. If I
select "AA" in cell K1 the color of the cells from A1 to K1 should change to red. If I select BB in "K1" the color of cells A1-K1 should change to green. In the similar way for other 5 conditions also. I am using Excel 2003 and it doest allow me to do this using Conditional formatting, as it will support only 3 conditions and I have 7 conditions. Thanks SR "Don Guillett" wrote: More info or do we just need to guess -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... rows "Don Guillett" wrote: rows/columns?? -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... Hi, I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all thse 5 cells depending up on the value in cell 5. Thanks in advance for your help. SR |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Change the color of a range of cells
I still don't understand. You can't do what I think you are saying. If desired, send your file to my address below along with this msg and a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... I have 7 different values in the cell "K1" such as AA,BB,CC,DD..etc. If I select "AA" in cell K1 the color of the cells from A1 to K1 should change to red. If I select BB in "K1" the color of cells A1-K1 should change to green. In the similar way for other 5 conditions also. I am using Excel 2003 and it doest allow me to do this using Conditional formatting, as it will support only 3 conditions and I have 7 conditions. Thanks SR "Don Guillett" wrote: More info or do we just need to guess -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... rows "Don Guillett" wrote: rows/columns?? -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... Hi, I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all thse 5 cells depending up on the value in cell 5. Thanks in advance for your help. SR |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Change the color of a range of cells
OP had a dropdown. I linked to this for a named range table.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < Columns("m").Column Then Exit Sub Cells(Target.Row, 1).Resize(, 13).Interior.ColorIndex = _ Application.VLookup(Target, Range("colorpicks"), 2, 0) End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... I still don't understand. You can't do what I think you are saying. If desired, send your file to my address below along with this msg and a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... I have 7 different values in the cell "K1" such as AA,BB,CC,DD..etc. If I select "AA" in cell K1 the color of the cells from A1 to K1 should change to red. If I select BB in "K1" the color of cells A1-K1 should change to green. In the similar way for other 5 conditions also. I am using Excel 2003 and it doest allow me to do this using Conditional formatting, as it will support only 3 conditions and I have 7 conditions. Thanks SR "Don Guillett" wrote: More info or do we just need to guess -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... rows "Don Guillett" wrote: rows/columns?? -- Don Guillett Microsoft MVP Excel SalesAid Software "Srajes" wrote in message ... Hi, I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all thse 5 cells depending up on the value in cell 5. Thanks in advance for your help. SR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the color of a range of cells | Excel Discussion (Misc queries) | |||
| change color of a range of cels in a row based on the value in one | New Users to Excel | |||
| change background color based on range value | New Users to Excel | |||
| change font color if number Range changes | Excel Worksheet Functions | |||
| How can you change the color of the selected range? | Excel Discussion (Misc queries) | |||
Linear Mode
