
How do I set up conditional formatting for all of the cells between I and R to change to Green if the cell is above the target cells (C) and red if it's below. I can't seem to find a way without setting it up for every single row individually. I realise this is probably something simple but I am quite new to this.
Thanks,
Andy