Cell matching into another cell

[Marc Evans]

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

[#2]

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.