Hi everyone, I'm new here.

I work with excel everyday, but sadly I dont know that much about VBA coding

Current I'm working with data in a table that looks like this:

A B C D E F G H I J
1
2
3
4
5


Column H has some text in it. The text that the code needs to look for is either "NET" or "RET". Based on which text string is in each row of column H it needs to then highlight that entire row inside the table with a given color. (at this point the color can be anything).

So essentially the code needs to check each row of column H inside the table for the text "NET" or "RET" and if found needs to color that row with a given color.


Thanks all. I tried earlier to do this with conditional formatting but I couldnt find any way to make it happen - but it may be possible using that method too?

Cheers,
Eventful