Dear sir,with best regards, i need your help for the request mentioned in attached file about the payments merit of the invoices coloured by conditional formatting .
Thanks in advance.
Dear sir,with best regards, i need your help for the request mentioned in attached file about the payments merit of the invoices coloured by conditional formatting .
Thanks in advance.
Last edited by tofimoon4; 07-21-2009 at 06:06 AM.
Change your existing CF formula in E6:E25 to:
=AND(B6 <> "", FLOOR(E6, 1) <= TODAY(), NOT(ISNUMBER(MATCH(B6, H:H, 0))))
Last edited by JBeaucaire; 07-19-2009 at 01:47 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Dear sir,many thanks for help,it works very nice.
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
Dear sir,with my appreciation and respect,i enclose herewith same example with some notes about the possibility to change and add to your wonderful solution,asking your goodself to help me for.
Thanking you in advance.
1) Don't know.
2) Formula change for E6, then copy down:
=IF(C6="","",DATE(YEAR(C6),MONTH(C6),DAY(C6)+15))
3) Highlight B6:E25 and put this CF formula in for the entire range:
=AND($B6<>"",FLOOR($E6,1)<=TODAY(),NOT(ISNUMBER(MATCH($B6,$H:$H,0))))
Dear sir,realy you are genius,thank you very much for help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks