Description: When you set conditional formatting on entire column and that's mark duplicate values, when you enter then a new duplicate, it gets aligned bottom. Steps to Reproduce: 1.Create conditional formatting to mark duplicate values in entire column 2.Enter new value which is duplicate Actual Results: Is aligned bottom Expected Results: Should be marked according to formatting Reproducible: Always User Profile Reset: No Additional Info:
The cell which has conditional formatting condition met should get formatting defined in the style defined by the format. If that style has alignment set to bottom, then so will be it. Please check if that's the case here; if not, then please attach a sample spreadsheet here to reproduce, and state your OS and LO version info (not only in metadata, but explicitly in the comment: metadata might be changed later, and only comments keep the history of what appeared where). When answered, please reset status back to UNCONFIRMED. Thanks.
I've thought so, but then checked with around 5 different styles. How can I check the configuration of style if it is defined so to align it bottom?
It's on cell style's Alignment tab; see Text Alignment->Vertical. If it's Default, then it seems to be equal to Bottom (possibly it depends on some other setting - like text direction - but for simple case, Default = Bottom).
Nah... you didn't get it. Cell's style is set good by me. Entire column's style is center (both in horizontal and vertical manner). The style changes to vertical-bottom, only when conditional formatting applies (i.e. formula (`COUNTIF($A:$A, A1)>1` is true). In this case text gets bottom aligned.
Got it. Solved. Thanks.