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

**patrickmcdiver** · 02-29-2012, 06:34 PM

First of all, let me say that I am very new to Excel (other than just typing stuff into the spreadsheet). That being said, please be gentle and speak as if talking to a child, lol.

I have a spread sheet that I am trying to manipulate. What I am trying to do is to get all rows that have a value entered into column "I" to turn red. Thanks for any help you can provide

**tom1977** · 02-29-2012, 06:39 PM

so click right button of mouse on the name of your sheet and select view code and paste this code in the window which appeared

Please Login or Register  to view this content.

**patrickmcdiver** · 02-29-2012, 06:53 PM

Thanks, Tom. However, it doesnt give me the option of choosing view code. I am assuming because there is none to view.

**tom1977** · 02-29-2012, 07:28 PM

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

**patrickmcdiver** · 03-01-2012, 11:30 AM

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

**patrickmcdiver** · 03-01-2012, 11:35 AM

Disregard my last reply. It worked beautifully, Tom. It just didn't do it with data that was already entered in the spreadsheet but as soon as I added something to another row, it worked!

Thanks so much!

**Markbendall** · 10-23-2012, 07:31 AM

Hi, I have exactly the same need but have tried this and it doesn't work for me. How does it know what coloum I enter my date in? Please help.
Thanks Mark

**arlu1201** · 10-23-2012, 08:04 AM

Markbendall,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.