Hello all... first-time poster here, with what I hope is a simple issue to
bounce off the group. I can't find information about this anywhere. It
isn't specifically addressed in any of the VBA resources I know of....

I believe this is similar to conditional formatting, but I'm trying to work
with entire rows, rather than just cells. Here's what I'm trying to do,
using VBA...

"If any cell in Column X contains value=Y, then perform Z on the entire
Row."

Examples:

If any cell in Column G contains the word "Apple", then the entire Row
containing that cell shuld be Red.

or

If any cell in Column D contains the word "Ohio", then delete the entire
Row.

Can expression be written in VBA? It seems like conditional formatting, but
it's not a "per cell" condition. Any suggestions will be greatly
appreciated.

- Scott