VBA macro code needed to highlight rows in a table given a specfic text in one column

Place the cursor in 2ND ROW and select the range which needs to be highlighted.

In Conditional Formatting formula

Formula:

=OR(TRIM($H2)="NET",TRIM($H2)="RET")

Apply the desired highlighting color.

The formula refers to 2nd row so active cell should be in 2nd row of the selection.