I have a trend graph measured in month periods that shows a trend line for a specific entity compared to a trend line for the average of all entities. I want to summarise that comparison in a separate worksheet listing all entities and showing for each month whether each entity's trend is above or below the average for all entities. Can anyone advise the best way to achieve this result?

In simple logic I want to determine: IF cell A is < than cell B then turn cell C (in another worksheet) green, IF NOT then turn cell C red.

Thank you in advance