by RusselB » Tue Nov 26, 2019 12:55 am
Welcome to the Forums.
I think you really want to have just one number from the list on Sheet 2 to be referenced in Sheet1.A5, rather than the full list.
If so, how do you want that to be selected/chosen?
Once we have that, then the rest can be done using either the STYLE function or Conditional Formatting.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.