Forum Discussion
Cell matching into another cell
Hi,
I need to cross reference values in 2 different cells, and depending on if one is higher or lower than the other populate a different cell with a colour. What I also want to do is depending on the difference between the numbers give it a colour.
i.e.
if the % of cell D < % of cell E is different by 10% or less then make cell F light green
if the % of cell D < % of cell E is different by 20% or less then make cell F dark green
if the % of cell D > % of cell E is different by 10% or less then make cell F orange
if the % of cell D > % of cell E is different by 20% or less then make cell F red
if the % of cell D & % of cell E is a match then make cell F red dark blue
Is this possible? Not an excel expert so simple language would be great if possible.
Many thanks
Hi Mark,
Sure. Apply Conditional Formatting (shall be in Ribbon menu) to cell F based on formula, five rules practically same way as you formulated them here. e.g. first rule =($D1-$E1)<0.1, select formatting (green) and apply to $F1.