Is it possible to use conditional formatting on a drop down list so it shows the text in a specific colour depending on a value on a separate sheet where the data is obtained from and already conditioned?
E.g. The fruit on the ‘Fruit tab’ is associated a number 1-3 which corresponds to a colour 1=red, 2=amber and 3=green. So when it is changed to another number between 1 and 3 the colour of the text change with it.
How can I get the text in the drop down list to maintain these conditions on the 2nd sheet when it is selected from the drop down list and updated if the number were to be change on the ‘Fruit tab’?
Bookmarks