I'm assuming that you created the dropdown list via data|validation.

Look at Format|Conditional formatting.

This won't shade the options, but it will shade the cell after you've updated
the cell.



creative schwabbie wrote:

Hi,

I've seen it in other sheets but can't figure out how to create one. I'm
trying to create a dropdown list that changes color whit each selection. For
instance, Pass = Green, Fail = Red and Not Executed = Yellow. I'm able the
create the dropdown list and put it in the cell but can't seem to give it
color. Does anyone know how?

Thanks!

--

Dave Peterson