 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Conditional Format an entire row
Using both Excel 2003 and 2007 (different machines) Example of what I am trying to do. I have a list of people's names and dates they are scheduled to volunteer. First name is in Column A, Last Name is in Column B, Date is in Column C. I want to set up a conditional format that will color the entire row (first name, last name, date) for an individual name. When I set my conditional format condition to check for "Fred" and color it green, I can get each cell in A colored green for Fred. But I want the whole row colored green so Fred can easily see the date he is scheduled to volunteer. Can you help?? Check out http://www.bettersolutions.com/excel/EPX299/YR217210552.htm for a visual. Highlight the entire block of data, the conditional formatting would be =$A1="Fred" HTH, JP > Using both Excel 2003 and 2007 (different machines) > [quoted text clipped - 9 lines] > > Can you help?? Excellent!! Thank you!! The conditional format condition had to be changed to "formula is" rather than "cell value is" for the whole row to be picked up. Check out http://www.bettersolutions.com/excel/EPX299/YR217210552.htm for a visual. Highlight the entire block of data, the conditional formatting would be =$A1="Fred" HTH, JP On Feb 1, 8:18 am, "BK" <nos...@nospam.com> wrote: > Using both Excel 2003 and 2007 (different machines) > [quoted text clipped - 12 lines] > > Can you help?? Glad to hear it worked! Thx, JP > Excellent!! Thank you!! The conditional format condition had to be changed > to "formula is" rather than "cell value is" for the whole row to be picked > up. Just to add to JP's solution, the active (white) cell of the selection must be in row 1 for this to work properly. Often it will be, but it's possible, depending on how the selection is made, for it to be elsewhere.  SignatureRegards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > Excellent!! Thank you!! The conditional format condition had to be changed to "formula > is" rather than "cell value is" for the whole row to be picked up. [quoted text clipped - 22 lines] >> >> Can you help?? Thanks for the input. My data actually starts in Row 3, but I made the adjustment to the conditional formatting formula. > Just to add to JP's solution, the active (white) cell of the selection > must be in row 1 for this to work properly. Often it will be, but it's [quoted text clipped - 29 lines] >>> >>> Can you help?? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.