Filtering data based on "Condition" created during conditional formatting

Hello everyone,

I’m having trouble finding a way to mark all cells with a certain condition, then filter for them. Basically, I need to mark all cells with a certain symbol ("/"), then filter so that I can only see those cells. The reason is that I need to do a text to columns iteration on a different cell in that same row.

Using conditional formatting, I can do various things to all cells containing “/”. I can turn them green, red, whatever.

Is there a way to then filter them, i.e. to filter only the cells marked “good”. Alternatively, is there a way to filter for all cells containing a specific symbol, which would circumvent this additional step?

Thank you!


you seem to mix things - “Filtering” and “Conditional Formatting” are two different things. “Filters” are applied to content of cells and not to properties of cells. In turn “Conditional Formatting” changes properties of cells.

If you want to filter all rows containing /:

  • Select the range you want to filter
  • Data -> More Filters -> Standard Filter...
    Field name column name or header (e.g Data in screenshot below)
    Condition Contains
    Value /
  • OK

image description

Hope that helps.

This helps, thank you! I understood the difference between conditions and content for filters, but thought that this additional step (change condition, then filter by condition) was the only way to do this. Worked perfectly though, thank you!

If the answers works for you, please consider to click the check mark (:heavy_check_mark:) next to the answer. Thanks in advance …

Quoting @anon73440385: " In turn ‘Conditional Formatting’ changes properties of cells."
That’s not quite correct. CF only overlays the respective attributes to the cell’s area in the view. Cell properties remain unchanged. This is the relevant difference between the usage of ConditionalFormatting and the usage of the STYLE() function - if applicable in the given case.
There are also CF modes (AllCells) producing results in the view for which simply no cell attributes exist.

See: compareAttributeByCFwithByStyle1.ods

Thanks for correcting my imprecise use of changes.

Creating an advanced filter, with the same conditions as the CF, adding to it the filter conditions, could help to get what it’s looking for.