Conditional formatting dates

[Closed]
Report
-
 Blocked Profile -
Hi
I am trying to format a date column on my spreadsheet and just can't see to get the formula right
Simplified, I have 2 columns, one with a deadline and one with a submission date. I want to made the deadline column red/amber/green if the deadline has passed today and the submission column is blank.
If there is a submission date then I need it to be red/amber/green for when it was submitted.
I have tried AND/IF/BLANK etc and just can't work it out.
Before submission I was thinking it needs to reference TODAY(), and after submission it'll be between the two columns?
It's been driving me insane all afternoon!!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!