+ Reply to Thread
Results 1 to 8 of 8

Change color of entire rows if a value is entered in a cell in column I

Hybrid View

patrickmcdiver Change color of entire rows... 02-29-2012, 06:34 PM
tom1977 Re: Change color of entire... 02-29-2012, 06:39 PM
patrickmcdiver Re: Change color of entire... 02-29-2012, 06:53 PM
tom1977 Re: Change color of entire... 02-29-2012, 07:28 PM
patrickmcdiver Re: Change color of entire... 03-01-2012, 11:30 AM
patrickmcdiver Re: Change color of entire... 03-01-2012, 11:35 AM
Markbendall Re: Change color of entire... 10-23-2012, 07:31 AM
arlu1201 Re: Change color of entire... 10-23-2012, 08:04 AM
  1. #1
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Change color of entire rows if a value is entered in a cell in column I

    try to press ALT + F11 then find in the left window name of sheet in which this macro should works and double-click this sheet. after this paste the code into widow which appear
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.

  2. #2
    Registered User
    Join Date
    12-10-2009
    Location
    Jacksonville, Fl
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Change color of entire rows if a value is entered in a cell in column I

    I tried exactly what you said but nothing happened. The code is written and in the proper place but none of the rows with a value entered into column "I" turned red. Basically, what I am trying to do is if a date is entered into column "I" then that means that task is complete and I want the whole row to turn red so I know to bypass that row (meaning it is complete and no longer needs my attention).

    thanks for your help thus far

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1