https://bugs.documentfoundation.org/show_bug.cgi?id=174303
BogdanB <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |g --- Comment #1 from BogdanB <[email protected]> --- You can already do this, but in another way: Highlight the cell or range in Sheet 2 where you are using the dropdown. Open Conditional Formatting: Go to Format > Conditional > Condition. Add rules for each option: Set up a rule for each choice in your list. For example, choose Cell Value is equal to (or use a formula like =$A2="YourOption") and assign the exact same background color you used in Sheet 1. Repeat for your other list items. No other software support this. >From me this bug could be close as a Wontfix. -- You are receiving this mail because: You are the assignee for the bug.
