New to Excel and new to this forum.

I am desperately trying to develop a formula or build a condition whereby a known expiry date is compared to todays date and if todays date is closer then 30 days or past due, then the expiry date is red and if not then shows/remains black.

I trust this must be an easy formula but I have no hair left to pull to figure it out any help would be greatly appreciated.

Mike