Re: $$Excel-Macros$$ Change Colour of a Cell if it contains certain value

2010-08-26 Thread solomon raju
Vaibhav, You shall apply conditional formatting! Regards, Solomon On Thu, Aug 26, 2010 at 9:26 PM, Vaaibhav Jhaverr wrote: > Hello All > > It has been really nice to be a part of this group in past. Learnt many > short tricks. > > I wanted help on how to change colour of cell if it satisfies a

$$Excel-Macros$$ Change Colour of a Cell if it contains certain value

2010-08-26 Thread Vaaibhav
Hello All It has been really nice to be a part of this group in past. Learnt many short tricks. I wanted help on how to change colour of cell if it satisfies a given criteria. Can we do the same for the complete row as well do highlight that row itself? Awaiting for your replies. Regards Vaaibha

$$Excel-Macros$$ Change Colour of a Cell if it contains certain value

2010-08-26 Thread Vaaibhav Jhaverr
Hello All It has been really nice to be a part of this group in past. Learnt many short tricks. I wanted help on how to change colour of cell if it satisfies a given criteria. Can we do the same for the complete row as well do highlight that row itself? Awaiting for your replies. Regards Vaaibha