View Single Post
  #2   Report Post  
olasa
 
Posts: n/a
Default


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