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
Bookmarks