conditional formatting...

Thank you, I didn't realise that was possible.

I've attached the spreadsheet I'm working on with some dummy data. Hopefully with the description above and this it may make a bit more sense.

Thanks again.