How do I make my selections different colors?

List/Menu Cell is on Sheet 3 and the Colored List/Menu is on Sheet 4. I’ve looked to see how to do this but there is something I am missing. As a secondary issue, how do you get each selection to highlight as the mouse moves over them?

image description

Trading Plan - Sample.ods

You can try the Conditional Formatting feature. It can apply existing cell styles based on one or more conditions, for example based on the cell content.


I have added more screenshots of what I have attempted to no avail…

Please upload a real, ods type sample file here.

File is above or at the link below: C:\fakepath\Trading Plan - Sample.ods

Please see my attached file at my Answer above.

Thank you very much, you are appreciated sir!

Please click on the “Solved” checkmark at the left side of my Answer - if your problem has been solved.