Hide rows and conditional formatting

**olga6542** · 05-02-2011, 05:53 PM

I need to hide rows if this conditional formatting is true =OR(O13<>"",ISNUMBER(SEARCH("cancel",P13)))

**TMS** · 05-02-2011, 06:00 PM

As far as I know, you can't hide rows with Conditional Formatting.

You could add a Helper column with that formula in it and then use Autofilter to hide the rows where the condition was true.

Regards

**olga6542** · 05-02-2011, 06:02 PM

OK. How about if Q7 equals to No, then hide the row.

**TMS** · 05-02-2011, 06:07 PM

No, sorry, there is no "hide row" format option available in Conditional Formatting. It doesn't matter what the formula is.

Regards

**olga6542** · 05-02-2011, 06:12 PM

I don't think you understood: =OR(O13<>"",ISNUMBER(SEARCH("cancel",P13))) was part of conditional formatting.
The entry in Q7 was not. ( It was regular formula not part of conditional formatting). Taking this under consideration, can I hide the cell if Q7 is no. I want to automate the spreadshet to the maxiumum.

**TMS** · 05-02-2011, 06:21 PM

Oh, OK then. Use Autofilter on column Q and select rows where the value is not equal to "no" without the quotes.

Regards

**olga6542** · 05-02-2011, 06:22 PM

I don't want to use auto filter, that's not automation.

**TMS** · 05-02-2011, 06:28 PM

Do you want a VBA solution?

**olga6542** · 05-02-2011, 06:29 PM

Yes, if know what macro should look like I would greatly appreciate it. I have a lot of cells Q7-Q90. This is the formula I have inputted in these cells: =IF(OR(O7<>"",COUNT(SEARCH({"cancel"},P7))),"No","Yes"), so if condition meets, I want to hide rows.

Help???