Hi Avinash, I think you can even do this without using macro... just apply conditional formating under tab Format
Regards On 2/25/09, Ashish Jain <26may.1...@gmail.com> wrote: > > > ---------------------------------------------------------------------------------------------------------------------------- > > ---------------------------------------------------------------------------------------------------------------------------- > Hi Avinash > > Here is the solution to your query: > > http://www.excelitems.com/2009/02/color-entirerow-based-on-columns-value.html > > Note: > 1. Links to Source File (Problem) and Target File(Solution) is on the > mentioned link. > 2. Rows can be sorted based on color, but in your case it's not possible > due to merged cell of different sizes. Please work on it then we can provide > solution to your problem. > 3. Instead of Buttons(Active,Deactive) we're using Data validation, which > is more efficient in terms of coding and time - since it serves the purpose > fully as desired. > > > For more tips, tricks, downloads and problem solutions: visit --> > http://www.excelitems.com > ------------------------------------------------------------------------ > Regards > Ashish Jain > Analyst and Demand-Co-ordinator, CSC Australia > Microsoft Certified Application (Excel) Specialist > Technical Trainer - Excel and VBA > Author -> www.excelitems.com > 09999-40-48-43 > > ---------------------------------------------------------------------------------------------------------------------------- > > ---------------------------------------------------------------------------------------------------------------------------- > On Tue, Feb 24, 2009 at 8:08 PM, Avinash Daga <avinashdag...@gmail.com>wrote: > >> >> >> Guys, >> >> I am new to VBA and advanced excel world and I need your help to improve >> project log which I have made so far to keep track of production work down >> by our team.Please help me as soon as possible and I really appreciate your >> effort for this. >> >> Here is the story for this - >> >> I have two buttons on column P which called active and deactivate.When I >> click active it should change color of that raw as green,means that project >> is active and once that is completed i can deactivate that by changing it to >> original text color. This is working for raw 1 but when I am dragging it >> down to make it work for all rows I am not able to do so.Please help me to >> have that thing changed for each raw. >> >> Also my second problem is once color is changed I want to have button or >> any kind of mechanism where I can sort out raw with color. >> >> I have used data validation on all columns where i don't want to user to >> write down any thing...but even I want to keep one cell open where user wish >> to enter any thing,he/she can do that. >> >> Thanks and Regards, >> Avinash >> >> 994-539-0501 >> >> >> >> >> > > > -- > Regards > Ashish Jain > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
