Icon Set or Arrows Conditional Formatting

[Seamus123]

Please direct me if this has already been covered in a thread I couldn't find. Below I have included an image of my sheet. Cells D10 through H14 are included in my appraisal reports and would like to have colour-coded arrows. I tried using icon set but it doesn appear to give me the result I am looking for. See the arrows in Coloumns R and X and my conditons next to them. Is it possible to write an IF formula so that cells D10 to H14 input coloured arrows referencing the percentages in cells J10 to N14? Basicall nominal adjustments range from 0 to 20% and can be positive or negative, thus with a green up or down arrow. There are also positive or negative moderate or maximum adjustments to be represented by yellow or red respectively.

 

[RoryA]

You can put simple link formulas in D10:H14 and then use conditional formatting. Note that if you want to format based on those percentage values, you want to use the Number option, not percent, in the conditional formatting dialog and enter say 0.4 for 40%

 

[Seamus123]

You can put simple link formulas in D10:H14 and then use conditional formatting. Note that if you want to format based on those percentage values, you want to use the Number option, not percent, in the conditional formatting dialog and enter say 0.4 for 40%

I am a tech zero and may be misunderstanding what you are trying to explain to me. The tip to use the number option helped. I was able to use Icon Set and the NUmber option to colour-code icons based on percentages in the same cell and simply clicke the checkbox that says show icon only. This allowed for the correct colour within the icon but I was not able to make it simultaneously give me directional arrows.