Conditional formatting

Taffy - Aug 7, 2015 at 04:34 AM
I need dates to be highlighted if over 6 months but to clear again if marked Y (completed) in another cell? I can obviously get the 6 month due to change but cant get it to change back if marked completed?