Hi Tobyriley,

Have a look at Conditional Formatting. Maybe it could make things much easier for you.