I have created a Data Validation List with R (Red), A (Amber) and G (Green) as the original list items, however, when it comes to selecting the drop down items, all three are Green.
How do I keep the formatting from the list items to carry through to the dropdown list?
Thanks,
Kim