If loop for values

[BravoGolf]

Hi all, I currently have the following if loop within my Excel chart..



Code
-------------------

=IF(F4<F22,"Increase","Decrease")

-------------------



Generally, it says that if F4 is less than F22, then write Increase
else write Decrease.

However, I already have a value on that cell which I dont want t
change (i.e. not replaced by Increase or Decrease). Is it possible t
change the background colour instead so that if F4 is less than F2
then change the background color to red or yellow, or generate an imag
like an up or down arrow

 

[Frank Kabel]

Hi
use 'Format - Conditional Format' for this