jq,
I can see what you mean but I only have one known date within the data e.g. Mot expiry date.

oldchippy,
not sure I get what you're suggesting.

Mind you, I feel as though I'm learning something, which is fantastic! Thanks alot both.

I think I need something that might combine both suggestions. It needs to use todays date to read how long till expiry then once within a range (use 'between' in con. frm.?) e.g. 14 days of expiry the row to change from white say to orange, then 7 days to red.

I would include an example but I'm unable to attach a zip file as we don't have a zip application!

Hope some of this make sense!

Again, thanks very much.