Re: $$Excel-Macros$$ how to use fillcolor for an condition

2010-01-17 Thread Ashok Renga
thanks for the quick reply thanks ankur and harmeet singh On 1/16/10, ankur wrote: > > Hi Ashok > Plz check the attached file > > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Sat, Jan 16, 2010 at 9

Re: $$Excel-Macros$$ how to use fillcolor for an condition

2010-01-15 Thread manan joshi
its quite simple use the conditional format. On Fri, Jan 15, 2010 at 10:29 PM, Harmeet Singh wrote: > Attached file would help... > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > On Fri, Jan 15, 2010 at 3:06 PM, Ashok Renga wrote: > >> >> >> >> when a>100 ,i need

Re: $$Excel-Macros$$ how to use fillcolor for an condition

2010-01-15 Thread Harmeet Singh
Attached file would help... Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Jan 15, 2010 at 3:06 PM, Ashok Renga wrote: > > > > when a>100 ,i need fill the box with green color > > > similarly when a<100,i need to fill the box with red colour > > > > can anyhelp on th

$$Excel-Macros$$ how to use fillcolor for an condition

2010-01-15 Thread Ashok Renga
when a>100 ,i need fill the box with green color similarly when a<100,i need to fill the box with red colour can anyhelp on thisss thanks ashok -- -- Some important links for excel users: 1. Follow us in TWITTE