Thank you so much for this, it is as perfect as I wanted.
One Love.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Sunday, March 11, 2012 12:14 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help: VBA code for
8aff74067d&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&biw=1066&bih=670
or tinyurl
http://tinyurl.com/6rozprj
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Saturday, March 10, 2012 10:06 PM
To: excel-macros@googlegroups.com
HI Don,
is this possible in pivot table ? .. i have three columns..a b & c.
a & b --having some order nos..& invoice no
& C is date..--todays, toms & earilier date..
if its earlier date -order nos & invo no.. should changeto red..
todays date - blue & toms date --green colr.. order