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.

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.