Thanks Aindril, I was little occupied and that's why not able to answer this in-time. Thanks.
Ruchi... I believe this has cleared your doubts. If you still feel some confusion, then please revert back. Thanks. Dilipandey -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Fri, Jun 12, 2009 at 10:03 AM, Aindril De <aind...@gmail.com> wrote: > Dear Ruchi, > > It is a custom format 0.00%;[Red]0.00% for the range. > > Regards, > Andy > > On Fri, Jun 12, 2009 at 1:20 AM, god is gr8 i love u < > ruchigab...@gmail.com> wrote: > >> >> hi dilip >> >> i wanna knw how u did this formating? >> plz tell me >> >> regards >> ruchi >> >> >> >> On Thu, Jun 11, 2009 at 10:53 PM, Dilip Pandey<dilipan...@gmail.com> >> wrote: >> > Hi Ramesh, >> > >> > Please find attached the solved workbook. >> > >> > Thanks, >> > -- >> > DILIP KUMAR PANDEY >> > MBA-HR,B COM(Hons.),BCA >> > Mobile: +91 9810929744 >> > dilipan...@gmail.com >> > dilipan...@yahoo.com >> > New Delhi - 110062 >> > On Thu, Jun 11, 2009 at 8:12 PM, Ramesh Katta <kr.sap...@gmail.com> >> wrote: >> >> >> >> Dear member, >> >> >> >> I have a question which was asked in interview. The question is how >> >> to apply color to range with using conditional formatting. >> >> >> >> For example i have range suppose a1:a20 containing negative and >> >> positive values. I need all negative numbers in red color and >> >> positive numbers in green color. (Without using conditional format). >> >> >> >> I attached a file for your reference. >> >> >> >> >> >> Thanks&Regards >> >> Ramesh >> >> >> >> >> > >> > >> > >> > >> > > >> > >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
