If loop to change background color

  • Thread starter Thread starter BravoGolf - ExcelForums.com
  • Start date Start date
B

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
 
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
 
Hi
see you other post

--
Regards
Frank Kabel
Frankfurt, Germany

"BravoGolf - ExcelForums.com"
 
Back
Top