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

ting .Please see attached file >> >> >> >> On Sat, Jun 7, 2014 at 5:32 PM, Ashish Kumar >> wrote: >> >>> Hi Keertee, >>> >>> PFA.!!! >>> >>> >>> Regards >>> Ashish >>> >>> On 7 J

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

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