Forum Discussion
Spread sheet does not show colour from drop down list.
I have created a dropdown list with Data and colour using Data validation. on sheet 1. Section of the cells to apply the drop down list only enters the data of the cell not the colour -main spreadsh...
You'll have to create conditional formatting rules for the cells with the data validation drop-downs: one rule for each value of the drop-down list.
Thankyou HansVogelaar
