Forum Discussion
Nested IF Statement with conditional formatting for 2 categories
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??
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?
