Conditional Formatting Date parameters
I have a date field that is used for a deadline. I'm using conditional formatting to color the date text red if the date is in the current week. The problem is if the date is past due over a week, the color does not stay red. It reverts back to the normal color if the date is post-dated over a week ago. Is there a condition that says, "if the date is after the deadline, keep it red."
I've tried using the "after" condition but there isn't a way to tell it "after" the field date. It only allows a string.
Thanks!