I have a summary spreadsheet that works a a dashboard for performance, cells
turn green or red using conditional formatting based on performace values
each month. The sheet conatins 12 months of data and the last column uses
conditional formatting to display an arrow showing whether there was an
improvement on last month or not. We have now been asked to turn the cell
containing the arrow amber if the trend based on the last 3 months only is
that we are going to fail to meet target. Has anyone got any ideas how we can
do this??
Thanks