Forum Discussion
rockj1050
Aug 18, 2023Copper Contributor
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...
HansVogelaar
Aug 18, 2023MVP
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.
- rockj1050Aug 23, 2023Copper Contributor
Thankyou HansVogelaar