Redacting a row in Excel based on a term.
Posted on 2016-11-30
I have a set of 20 Excel files that need to have information redacted from them. For the purpose of redaction, I just need to change the background and text to black.
For each row in my worksheet, I want to search for the text ‘Acme’. If ‘Acme’ can’t be found in any field for a given row, I want to redact the entire row.
Does anyone know of the best way to do this? I know that Conditional Formatting, Macros and COM automation are all options. I am hoping someone can give me some direction to limit my research time.
Thank you in advance.