Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
color formating
I would like to have one or more cells change cells if a cell below = a
certain thing. Would it be possible in a VLOOKUP to assign different cells in the column different colors that would be linked to the cells above the VLOOKUP cell. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
color formating
Russell
I would suggest using "Conditional Formatting" if the required range of colors is no more than 4 colors. If it's more than that, I don't think you can achieve this without coding. For conditional formatting, change the condition paramater to "Formula is", then add a formula that refers to the cell above, and describes your condition. For example, if your logic is that if the cell above (say B10) is greater than 10 but less than 20, then your conditonal format formula would be "=and(B1010,B10<20)", and then you can use the "Format" button to describe the formatting you would like to apply in these circumstances. You can make up to three conditions, and you can achieve the fourth color by shading all the cells this color. The cells that meet one of the three conditions will change color, and the ones that don't will remain as you shaded it. Hope this makes sense. Daniel "Russell Anderson scratching his head" wrote: I would like to have one or more cells change cells if a cell below = a certain thing. Would it be possible in a VLOOKUP to assign different cells in the column different colors that would be linked to the cells above the VLOOKUP cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Color Formating | Excel Discussion (Misc queries) | |||
Excel 2002: Formating tab color | Excel Discussion (Misc queries) | |||
autoshape color conditional formating | Excel Discussion (Misc queries) | |||
Change color without conditional formating | Excel Discussion (Misc queries) | |||
color formating ontingenton upon another cell? | Excel Discussion (Misc queries) |