Fill range of rows based on a value

Hello, I need your help. I'm very new to macros in excel so what I wanted to do is to
change the range colors of the rows from A1:W50 based on a value.

For example if there's a value named Apple in Column A1, the code will highlight the row until Column W because that
row have the value Apple.

I hope that was clear.

Thank You

Maybe:

Please Login or Register  to view this content.

You should be able to see where to change the values and colors accordingly. You may need to alter code to match your sheet name.

Ok so I tried it, and that's exactly what I need. I tried changing the value "Apple" to Column D but what happened was it highlighted Column D to W. I still want Columns A,B and C to be highlighted even if the value of the Apple is not on A how do you do that?

Well, you should have said so in the beginning. Altering just 1 thing can completely change the way code works.

Please Login or Register  to view this content.

Thank You!