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