Created attachment 175075 [details] Example of Color in number format It is possible now to filter on colors. However, that covers only text color and background color. But it is possible to set colors in number-format. That is in the predefined number formats done for negative numbers. But you can define number-formats with other colors and other ranges too. Such example is attached. Number-formats with colors can be used for the y-axis in charts too. To include colors from number-format in a filter is important for exchange with Google Tables. That application considers colors set by number-format the same as colors set by text format.
Samuel Mehrbrodt committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/240c2410973e5eec1793656538619560a28a500f tdf#144549 Consider number format colors when filtering/sorting by color It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2c4bfbf224aa5ced905bbe569ca56ecf5e00115f tdf#144549: sc: Add UItest It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.