Cell matching into another cell

Copper Contributor

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

1 Reply

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.