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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com