The coloring effect can be achieved via applying conditional format on the DV
cells.
Assume your DV list is applied to col A.
Select col A (A1 active),
click Format Cond Formatting, and apply it as:
Condition 1, Formula is:
=A1="Pass"
Format: Green fill
Condition 2, Formula is:
=A1="Not Executed"
Format: Yellow fill
Condition 3, Formula is:
=A1="Fail"
Format: Red fill
Click to OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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!