How can I use conditional formatting to filter by?

[smbhatt]

How to do a Colour Filter like in Excel 2010?

[Copied from OP’s “answer”:]

Difficult to explain. On dfining ‘filter’ if the column has colours based on some condition, then in the drop down list of filter, you can select that colour to see only those rows hainv that color. You need to see it in Excel to understand. Beautiful utility. Yes it is conditional formatting but LibO doesnot have that type of conditional filter.

[mariosv]

Maybe you are talking about conditional formatting?

[smbhatt]

Difficult to explain. On dfining ‘filter’ if the column has colours based on some condition, then in the drop down list of filter, you can select that colour to see only those rows hainv that color. You need to see it in Excel to understand. Beautiful utility.
Yes it is conditional formatting but LibO doesnot have that type of conditional filter.