Feb 16 2017
06:08 AM
- last edited on
Jul 25 2018
09:26 AM
by
TechCommunityAP
Feb 16 2017
06:08 AM
- last edited on
Jul 25 2018
09:26 AM
by
TechCommunityAP
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
Feb 16 2017 06:29 AM
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.