I have a column of invoice dates. I need to set it up to where either A) the
dates change colors, OR B) a check mark is placed in the 35 day column, when
it has been 35 days or more since the invoice date.

I've tried conditional formatting, but I can't seem to get the formula
right.

It would also be nice if those dates did NOT change color if the PAID cell
has been filled.

So, I would like them to change color if they are over 35 days AND if the
paid cell is blank.

I hope I've explained well enough for my problem to be understood.

Jess*