Hi alfaholic,

Thanks for the response.
Yeah, I understand conditional formatting however I can't see how it can help me as I want the row to change to a specific colour when there is say 7 days to go before the mot expires.
Don't want much, do I? lol

I've seen similar on data sheets where I used to work so I'm sure there is a way but personally can't find out how.

Thanks again.