I want to have conditional formatting comparing 2 dates:
Where [Actual] > [Due Date], column will be red
Where [Actual] < = [Due Date], column will be green
Where [Due Date] has a value but [Actual] is blank, I would like to assume today's date for Actual.
Where [Due Date] is blank, but [Actual] is not, I'd like it to be green.
Where [Due Date] & [Actual] are blank, I would like it to not evaluate/not be colored red or green.
I know I need a helper column, but I'm getting stuck on how to implement it to evaluate properly where dates are left blank.
