Re: $$Excel-Macros$$ conditional formating to find amts to offset

2013-03-24 Thread prafull jadhav
Dear Santosh, find the same ...with 3)amts have to be equally opposite. Regards, prafull. On Mon, Mar 25, 2013 at 11:41 AM, अनिल नारायण गवली wrote: > Dear SantoshKumar.Subudhi, > > Pl see the attach sheet. > > Warm Regards, > Gawli Anil. > > On Mon, Mar 25, 2013 at 11:35 AM, santosh subudhi <

Re: $$Excel-Macros$$ conditional formating to find amts to offset

2013-03-24 Thread अनिल नारायण गवली
Dear SantoshKumar.Subudhi, Pl see the attach sheet. Warm Regards, Gawli Anil. On Mon, Mar 25, 2013 at 11:35 AM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hello Prafull, > > Thank you for your early reply. > > The solution provided by you contains only two criteria's ,it does't

RE: $$Excel-Macros$$ conditional formating to find amts to offset

2013-03-24 Thread santosh subudhi
Hello Prafull, Thank you for your early reply. The solution provided by you contains only two criteria's ,it does't include the amt criteria ,if i change the amount the text should change to invalid. Let me make it more clear: 1)customer name has to be same 2)profit centers have to be same 3)

Re: $$Excel-Macros$$ conditional formating to find amts to offset

2013-03-24 Thread prafull jadhav
HI , find the same if it is as per your requirement . Regards, prafull jadhav. On Sun, Mar 24, 2013 at 2:27 PM, David Grugeon wrote: > I want to know where we are going next with this. What happens if the > amounts are different? > > > On Sunday, 24 March 2013, santosh subudhi wrote: > >> Hell

Re: $$Excel-Macros$$ conditional formating to find amts to offset

2013-03-24 Thread David Grugeon
I want to know where we are going next with this. What happens if the amounts are different? On Sunday, 24 March 2013, santosh subudhi wrote: > Hello Group, > > I need a way to highlight the amts that I can offset with each other based > on the below conditions: > > 1) Customer should be same >

$$Excel-Macros$$ conditional formating to find amts to offset

2013-03-24 Thread santosh subudhi
Hello Group, I need a way to highlight the amts that I can offset with each other based on the below conditions: 1) Customer should be same 2) Profit Center has to be same I need to do this *with out macros.* * * Any type of help would be of great help. -- Regards Santosh santoshkumar.subu...@g