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 <[email protected]>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<[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] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
