Due Date Flagging
 

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*

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

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

That should do it
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390792