How to compare two cells in a worksheet and show the result as red or green in a cell in another wor
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
|