Re: $$Excel-Macros$$ Conditional formatting help - file attached

2014-10-01 Thread Vaibhav Joshi
check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 4:25 PM, Pravin Gunjal wrote: > Hello Friends, > > I have attached an excel file, in which Column D, M and Y are very > important in this file. > > *I need the following :*

$$Excel-Macros$$ Conditional formatting help - file attached

2014-10-01 Thread Pravin Gunjal
Hello Friends, I have attached an excel file, in which Column D, M and Y are very important in this file. *I need the following :* If a Division (Col D) has crossed 30 days (Col Y) and still not received an acknowledgement copy (Col M) then the entire row (from Column A to Y) must be highlighted