Re: $$Excel-Macros$$ assigning color to cells on basis of value

2014-06-26 Thread Keertee Taneja
Thank you ! On Sat, Jun 7, 2014 at 8:25 PM, Sunny Chauhan wrote: > Hi > > Please find the attached file... > > > > > Warm Regards, > Sunny Chauhan > > > On Sat, Jun 7, 2014 at 8:16 PM, ashish koul wrote: > >> You can do it using conditional formatting .Please see attached file >> >> >> >> On S

Re: $$Excel-Macros$$ assigning color to cells on basis of value

2014-06-07 Thread Ashish Kumar
Hi Keertee, PFA.!!! Regards Ashish On 7 June 2014 15:28, Keertee Taneja wrote: > > > I have drawn up an this excel sheet which contains returns on a security. > It contains both positive and negative values. I want to assign different > colours to positive and negative values. How can I d

$$Excel-Macros$$ assigning color to cells on basis of value

2014-06-07 Thread Keertee Taneja
I have drawn up an this excel sheet which contains returns on a security. It contains both positive and negative values. I want to assign different colours to positive and negative values. How can I do both of them together. I used conditional formatting of greater than 0 it highlighted the p