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
