If loop to change background color

[BravoGolf - ExcelForums.com]

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

=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

 

[icestationzbra]

what you want done, can be done in VBA (if you do not want to involv
additional columns).

or

another method would be to use a helper column and enter 'increase' o
'decrease' over there. based on that, you could conditionally forma
another cell to change font or background colour

 

[Frank Kabel]

Hi
see you other post

--
Regards
Frank Kabel
Frankfurt, Germany

"BravoGolf - ExcelForums.com"