Due Date Flagging

[Guest]

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*

 

[olasa]

In the Conditional Formatting instead of Cell Values Is: select Formul
Is: and write...
=AND((TODAY()-A1)>35,B1="")

A1 referes to Invoice date
B1 referes to "Paid" or ""

That should do it
Ola Sandströ