I have a table in the worksheet 'Central'.
This table currently occupies cells B7 to G1000.
The length of the table may vary. So G10001 or more rows.
The data found on first column of the table on column B7 to B????,
there are a series of 'YES' or 'NO' or other text on each cell going
down.

Is it possible for a macro to go through each cell in column B7 to
B???? in the table and delete the entire record row if the criteria
text 'NO' is identified in the cell and remove the formatting and
colors for the other rows which does not have 'NO' as a text.

Can this be done by VBA and without the excel filters?

Appreicate you help in advance...


Many thanks.