Hi Darren,
The formula results are still not working the way it is intended to work. Please see attached chart – if you scroll to the very start of the chart there are green stars when there are no red stars. I basically am trying to achieve a green star where a red star has appeared provided it is within 80 days of the red star occurring (and this should apply for daily, weekly and monthly charts accordingly). I have tried all types of combinations of codes and if functions but cannot get it to work.
Can you please have a look at it and let me know what is wrong with the formula please.
Thanks and kind regards,
Karen
