Thanks Dilip, Infact I missed the green part too.. in the custom format...
Regards, Aindril On Fri, Jun 12, 2009 at 4:22 PM, Dilip Pandey <[email protected]> wrote: > Hi Ramesh / Anidril, > > Just realised that I forgot the Green part in the custom format. Use > following format to match up the requirement:- > > [Green]0.00%;[Red]0.00% > > Note:- Solved excel workbook is also attached herewith. > Thanks. > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > [email protected] > [email protected] > New Delhi - 110062 > > On Fri, Jun 12, 2009 at 8:04 AM, Aindril De <[email protected]> wrote: > >> Hi Ramesh, >> >> Just to add what Dilip has provided as solution. If your question was that >> the -ve values shd be in red and the +values shd be in green. >> Just before adding the custom format: 0.00%;[Red]0.00% as mentioned by >> Dilip. please change the default font color to green. Then you shd apply the >> custom format mentioned. >> >> Regards, >> Andy >> >> On Fri, Jun 12, 2009 at 12:23 AM, Dilip Pandey <[email protected]>wrote: >> >>> *Hi Ramesh,* >>> >>> Please find attached the solved workbook. >>> >>> Thanks, >>> -- >>> DILIP KUMAR PANDEY >>> MBA-HR,B COM(Hons.),BCA >>> Mobile: +91 9810929744 >>> [email protected] >>> [email protected] >>> New Delhi - 110062 >>> On Thu, Jun 11, 2009 at 8:12 PM, Ramesh Katta <[email protected]>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 [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
