With Cell Styles selected from Styles and Formatting (F11), select a style, and all cells on the current sheet that are formatted with that style are highlighted.
The highlighting could mean an overlay, different color, dashed lines.
Currently it works the other way around. The user clicks a cell and the style is highlighted in the Styles and Formatting panel.
Please see attached image.
It would be helpful to see, all cells using style "X", especially if converting spreadsheets from direct formatting to styles.
User Profile Reset: No
Created attachment 148300 [details]
Image of enhancement - Select style highlights cells
You do the trick per Edit > Find & Replace (Ctrl+H), check Cell Styles, select the style, and Find All. All cells with the respective style are highlighted (blue frame). => WFM
Btw, this works also in Writer.