Ah i had managed to do the conditional formatting but i had to do each row individually so was hoping of a quicker way

Thanks