Dear Manoj, you are welcome...!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062
On Mon, Jan 18, 2010 at 4:56 PM, Manoj S Negi < manojsnegi.uttranc...@gmail.com> wrote: > Thank you so much Dilip. > > Now its working fine. > > > > *Unfeigned Regards > Manoj S Negi > Skype - manojsnegi > * > > On Fri, Jan 15, 2010 at 3:23 PM, Dilip Pandey <dilipan...@gmail.com>wrote: > >> Dear Manoj, >> >> As requested, please find below the process. >> >> Assume you want to do conditional formatting in entire row 2, if it has >> some specific text i.e, (DILIpandey) in column B. >> so if B2 has value as "DILIpandey", then entire row will change to Red. >> >> Steps:- >> >> 1) Select the entire row # 2, by clicking on the 2 with left button of >> mouse. >> 2) Press Alt + O + D >> 3) Change "Cell Value Is" to "Formula is" by selecting the same from drop >> down. >> 4) Apply the followig formula in next field >> =$B$2="DILIpandey" >> >> 5) click on "Format" button and select the pattern as Red color >> 6) click OK and you should be done. >> >> check:=> go to each cell and you'll find the formula as >> =$B$2="DILIpandey", which means if B2 is having DILIpandey, then only it >> will change to Red in color. See the dollor sign which is used to fixed the >> reference and will not allow to move the reference. >> >> If you got the logic, then you can add other conditions as well and do the >> task. >> >> Best Regards, >> >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On Thu, Jan 14, 2010 at 10:55 AM, Manoj S Negi < >> manojsnegi.uttranc...@gmail.com> wrote: >> >>> Hi Mr. Dilip, >>> >>> Its working fine as I was looking. >>> Kindly let me know how you have done it as the process you have described >>> in the attachment, I am doing the same but not able to apply the required >>> format on required row as its applying on the selected cell only. >>> >>> >>> >>> Unfeigned Regards >>> Manoj S Negi >>> Skype - manojsnegi >>> >>> >>> ---------- Forwarded message ---------- >>> From: Dilip Pandey <dilipan...@gmail.com> >>> Date: Wed, Jan 13, 2010 at 3:08 PM >>> Subject: Re: $$Excel-Macros$$ Help required in conditional formatting >>> To: excel-macros@googlegroups.com >>> Cc: manojsnegi.uttranc...@gmail.com >>> >>> >>> Hi Manoj, >>> >>> Solution is revised and on the next sheet tab, I have tried explaining >>> about the conditional formatting logics which I had used. Hope that will >>> help you understand the solution. >>> >>> Let me know in case you still have some queries. >>> >>> Best Regards, >>> -- >>> DILIP KUMAR PANDEY >>> MBA-HR,B COM(Hons.),BCA >>> Mobile: +91 9810929744 >>> dilipan...@gmail.com >>> dilipan...@yahoo.com >>> New Delhi - 110062 >>> >>> >>> On Tue, Jan 12, 2010 at 8:46 PM, Manoj S Negi < >>> manojsnegi.uttranc...@gmail.com> wrote: >>> >>>> >>>> Adding in the same mail in bold letters........ >>>> >>>> >>>> Hi Dilip, >>>> >>>> Thanks for your efforts but please tell me how it works as I want >>>> whenever the entire column* D* will have the value *(In process or in >>>> progress)* than color of specified row (e.g.cell A2 to I2) should >>>> change as per the specified color(e.g. Yellow or Red). >>>> >>>> *And the file you have sent me, In that file said formatting is working >>>> for those two rows only not for others.* >>>> >>>> >>>> >>>> *Unfeigned Regards >>>> Manoj S Negi >>>> Skype - manojsnegi >>>> * >>>> >>>> ---------- Forwarded message ---------- >>>> From: Dilip Pandey <dilipan...@gmail.com> >>>> Date: Tue, Jan 12, 2010 at 8:13 PM >>>> Subject: Re: $$Excel-Macros$$ Help required in conditional formatting >>>> To: excel-macros@googlegroups.com >>>> >>>> >>>> Dear Manoj, >>>> >>>> Attached file (Excel 2003) version has been solved per your requiremtn >>>> and re-attached. >>>> >>>> Best Regards, >>>> -- >>>> DILIP KUMAR PANDEY >>>> MBA-HR,B COM(Hons.),BCA >>>> Mobile: +91 9810929744 >>>> dilipan...@gmail.com >>>> dilipan...@yahoo.com >>>> New Delhi - 110062 >>>> >>>> >>>> On Tue, Jan 12, 2010 at 5:13 PM, Manoj S Negi < >>>> manojsnegi.uttranc...@gmail.com> wrote: >>>> >>>>> Hi All, >>>>> >>>>> Refer to the mail subject kindly help me in conditional formatting as >>>>> per below mentioned condition... >>>>> * >>>>> "How to change the format of a particular row's format based on an >>>>> particular cell's value".* >>>>> >>>>> Files are also attached for further reference. >>>>> Right now I am using Excel 2007 therefore I have attached two version >>>>> file. (Excel 2003 & Excel 2007) >>>>> >>>>> >>>>> >>>>> *Unfeigned Regards >>>>> Manoj S Negi >>>>> Skype - manojsnegi* >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us in TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>>> http://www.excelitems.com >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> If you find any spam message in the group, please send an email to: >>>>> Ayush Jain @ jainayus...@gmail.com >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> HELP US GROW !! >>>>> >>>>> We reach over 6,500 subscribers worldwide and receive many nice notes >>>>> about the learning and support from the group.Let friends and co-workers >>>>> know they can subscribe to group at >>>>> http://groups.google.com/group/excel-macros/subscribe >>>>> >>>>> >>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us in TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>> http://www.excelitems.com >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> If you find any spam message in the group, please send an email to: >>>> Ayush Jain @ jainayus...@gmail.com >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,500 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>>> >>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us in TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>> http://www.excelitems.com >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> If you find any spam message in the group, please send an email to: >>>> Ayush Jain @ jainayus...@gmail.com >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,500 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>>> >>> >>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us in TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,500 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >>> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us in TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,500 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe >
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
