Can't seem to work this one out.

Col A has dates in it. If today is either a Friday, Saturday or
Sunday, and the date in A is more than 1 yr before the coming Sunday's
date (or today's date if today is Sunday) conditionally format (turn
red, underline, whatever) A. If today is any other day and the date
in A is more than 1 yr before today, conditionally format (turn
red...etc) A.

I hope I've explained that clearly.

(Need it to work for leap years as well as ordinary years.)

Regards