Nested IF Statement with conditional formatting for 2 categories

[Julia Mariuska Hodgins]

I am trying to build a macro containing a way to select and delete rows when they have 2 types of text (categories of a variable) in one specific column. I believe I will need a way to identify those categories (Conditional Formatting) and an IF statement. Is there a better way that someone knows??

[#2]

Julia-

It would be helpful if you provide some further context.  Could you please attach a non-sensitive file with an example of how your data is represented?  Is there any other information you can provide that may be relevant?

Thoughts on your inquiry:

-I doubt you'll need any conditional formatting

-When you say select and delete rows what do you mean be this?  Select entire rows then click a button to run the macro?  Select a few cells and the click a button?

-What are the values of the category?  If "X" then delete the row? If "Y" leave the row untouched?  What column is the category in?