Conditional Formating

[Ted Dennis]

I am looking to illustrate the movement of a value in relation to another.

I have figures in column I which is this months data, I have figures in column J which was the previuos months data. In column K I am showing the change between last months data and this months. but I want to show this as a value but also as a arrow showing whther the value has increased, decreased or atayed the same. I have played around with conditional formating but to no avail. I am using excel 2010

Ma ny thanks for your help

[Fotis1991]

Maybe In Conditional format rules.

=I1=JI >>>yELLOW

=i1>ji >>>Green

=I1<JI >>RED

Range KI:K1000...