Issue applying conditional formatting to a symbols drop down
In the far left column of my sheet I have a "status" column which is a dropdown of yellow, red, and green symbols which indicate the general status of the project. I would like to apply conditional formatting which will automatically change this column to red/green/yellow based on conditions in the "difference" column, on the far right.
It seems that conditional formatting only lets me change certain things about a cell or row, like font and background color...is it possible to have conditional formatting apply to a dropdown menu?
Any help would be greatly appreciated.